Arafath Posted August 23, 2015 Share Posted August 23, 2015 i have a table with more than 30000 records. how to speed up search. can use redis? Quote Link to comment https://forums.phpfreaks.com/topic/297907-speed-up-mysql-search/ Share on other sites More sharing options...
CroNiX Posted August 23, 2015 Share Posted August 23, 2015 Lots of ways. How about posting your schema? Is everything properly indexed, especially fields that are being joined on, used in WHERE's, etc? 30,000 records is nothing... Quote Link to comment https://forums.phpfreaks.com/topic/297907-speed-up-mysql-search/#findComment-1519511 Share on other sites More sharing options...
Barand Posted August 24, 2015 Share Posted August 24, 2015 Also post the query/ies that are giving the problem. Rewriting the SQL can often have significant performance increase. Quote Link to comment https://forums.phpfreaks.com/topic/297907-speed-up-mysql-search/#findComment-1519530 Share on other sites More sharing options...
Arafath Posted August 24, 2015 Author Share Posted August 24, 2015 sorry not 30,000, the record is 300,000 Quote Link to comment https://forums.phpfreaks.com/topic/297907-speed-up-mysql-search/#findComment-1519534 Share on other sites More sharing options...
Barand Posted August 24, 2015 Share Posted August 24, 2015 Still not excessively large. I've worked on tables with 30 million+ records and still got query results back in under a second. Now what about those table structures and queries if you want help? We won't keep asking. Quote Link to comment https://forums.phpfreaks.com/topic/297907-speed-up-mysql-search/#findComment-1519537 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.