I have a mysql query that with large data sets does not complete. I need a mysql expert to tell me where the bottlenecks are and revise to complete faster. With the largest data set, current run time for a limit of 5 rows is over 3 minutes. With all rows 9,000 plus it does not complete. Attached is the query code. I know some variables are missing and I can give the full tables and parameters to reproduce the query. I need to reduce the run time significantly! Thanks for your help.
45 pekerja bebas membida secara purata $178 untuk pekerjaan ini
Sir, I have gone through your project description and am looking to provide my service for the query optimization. For more than 7 years I’ve worked in this field.