I need someone to optimize or repair out database queries. They are bogging down the database.
Here is what I have been reported.
+Large rows and slow queries
Many tables such as exp_member_homepage (704,825 rows) exp_members (704,840 rows), and exp_member_data (704,838 rows) are very large in size. Besides these, I also counted about 10+ tables with 10,000-20,000 rows. The size of these tables used in conjunction with inefficient queries leads to slow queries, which I believe is the biggest culprit for the slow site speeds. Your MySQL slow queries log has grown to almost 358MB in just a few days. This log can be found at the following path:
/var/log/[url removed, login to view]
As a courtesy, I analyzed some of your slow queries, and see a large amount of queries that use 'SELECT *' in some of your largest tables. These types of queries appear to be the largest cause of your bottleneck, as they have to comb through 704,000+ records. Optimizing how your site utilizes MySQL will benefit you the greatest.
Dear PCTOC, I have studied you project requirement about query optimization and interested to work on it Could you please check private message for more details Thanks Jolly
15 freelancers are bidding on average $577 for this job
You need to use indexes with that sort of data. I can help you identify where you need indexes and also limit the amount of data that must be collected and sorted.