Home Simple Select Query taking long time to execute
Reply: 0

Simple Select Query taking long time to execute

user7468
1#
user7468 Published in September 19, 2018, 6:47 pm
select id, subject, date, source 
from TABLE_NAME 
where source = 'ABC' 
order by date desc

The above query fetches only 917 rows (out of 300,000 rows), but needs almost 3 minutes

What could be the problem?

share|improve this question
  • This doesn't make sense. How many rows do you have your table? – FLICKER Nov 14 '17 at 7:51
  • about 300,000 records – Faisal Nov 14 '17 at 7:53
  • 1
    For example locking by other sessions. Express edition could use 1GB RAM. – Lukasz Szozda Nov 14 '17 at 8:09

1 Answer 1

active oldest votes
up vote 0 down vote
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.308601 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO