Php Mysql Query Taking Too Much Time Stack Overflow I've got a query with several joins in that takes 0.9 seconds when run using the mysql cli. i'm now trying to run the same query on a php site and it's taking 8 seconds. there are some other big joins on the site that are obviously slower, but this string is taking much too long. Our software runs on a cluster of apache php application servers, powered by a mysql backend. on one particular instance of the software, the php code to query the list of category names is timing out when the customer has more than 29 categories.
Mysql Query Optimisation Sql Query Is Taking Too Much Time Stack I would do an internal prequery of the product id, count and time specific to the merchant you want. otherwise, as in gordon's query sample, i was prequerying every product first, then outside of that getting those for the merchant. I am trying to optimize the sql query listed below. it is basically a search engine code that retrieves products based on the products name. it also checks products model number and whether or not. Besides php 4.9 being really outdated (you should advise your boss to upgrade), did you ever run explain on your queries? what kind of indices are set for the tables?. Our company has been using this system for a long time and people feel huge system slowdown. i can't rewrite code because its super hardcoded and too many files to do so.
Optimization Mysql Query Taking Too Much Time While All Columns Are Besides php 4.9 being really outdated (you should advise your boss to upgrade), did you ever run explain on your queries? what kind of indices are set for the tables?. Our company has been using this system for a long time and people feel huge system slowdown. i can't rewrite code because its super hardcoded and too many files to do so. Learn how to find and tune a slow mysql query with our mysql 101 guide. identify bottlenecks and optimize performance with or without pmm.
Comments are closed.