Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
@ultrono even without indexing how om earth the query took 2 minutes or even 55 seconds ? Maybe you shoukd remodel your database or think about database designing. Have you considered using elastisearch or solr?
-
@anekix All good points but unfortunately it's a legacy project that the client isn't willing to spend a huge amount of money. In a perfect world I'd do all the things you suggest :)
Related Rants
How a web application works
At the moment I'm trying to optimize a slow old MySQL query from a project I made several years ago. The execution time is in excess of 55 seconds. Not good :(
After about an hour of experimenting I finally set a good index and reduced the time to < 3 seconds.
Chuffed :)
undefined
mysql
indexes