How to optimize php+mysql tens of millions of data fuzzy query query speed is im

A recent project, Win2003 apache+php+mysql configuration environment, because the project is the traffic management, data storage capacity is large, the table is millions of less, a long time will have tens of millions of records. 

Now the part of query optimization, query the like fuzzy query corresponding time segment query is very slow, a short period of time the amount of data is not too much can also, if millions of data difference is very slow. 

I do not know your master have any mature project results can share, or to give reasonable suggestions from the server WEB environment, hardware equipment, management system architecture and database table design choice, etc. 

Please a lot of published personal recommendations, here thanks. 

Soundcloud Downloader - Download any music tracks from SoundCloud.

Started by Alex Hodges at January 28, 2019 - 8:16 PM