Jump to content

Speeding Up A Big Database Query


michaellunsford

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.