michaellunsford Posted December 4, 2012 Share Posted December 4, 2012 So, I have SELECT * FROM `calendar` WHERE `DATE` >= '2012-12-04' ORDER BY `DATE` ASC LIMIT 0,30 The database hits some 10,000 records to find out which ones are today or future, which can really clock the database. Is there a way to manipulate the query or database so that it knows not to hit all 10,000 records in the search? I'd rather not separate the main table into two different ones, but that's about all I can come up with. Other ideas? Link to comment https://forums.phpfreaks.com/topic/271608-speeding-up-a-big-database-query/ Share on other sites More sharing options...
Barand Posted December 4, 2012 Share Posted December 4, 2012 Do you have an index on date column? Link to comment https://forums.phpfreaks.com/topic/271608-speeding-up-a-big-database-query/#findComment-1397565 Share on other sites More sharing options...
michaellunsford Posted December 4, 2012 Author Share Posted December 4, 2012 I'm not terribly good at indexes, but I just added one that includes the date field. Is it that easy, or do I need to write the query differently to take advantage? Link to comment https://forums.phpfreaks.com/topic/271608-speeding-up-a-big-database-query/#findComment-1397569 Share on other sites More sharing options...
Barand Posted December 4, 2012 Share Posted December 4, 2012 The question you should be asking is "Is it any faster with the index?" Link to comment https://forums.phpfreaks.com/topic/271608-speeding-up-a-big-database-query/#findComment-1397589 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.