Get a Freelance Job

I have a fairly complex mysql query which needs to be optimized.
Please bid on this project if you are a mysql optimization expert.

I’ll need you to advise on which indexes should be created for this specific query.
Also I’ll need advise if and how we need to rewrite the query.

I can send you the query over private message before you bid.

Only mysql optimization experts please.

I have a fairly complex mysql query which needs to be optimized.
Please bid on this project if you are a mysql optimization expert.

I’ll need you to advise on which indexes should be created for this specific query.
Also I’ll need advise if and how we need to rewrite the query.

I can send you the query over private message before you bid.

Only mysql optimization experts please.

I need someone who has experience with x-cart 4.2.x and can help me benchmark and optimize two sections of my website. I need this completed a.s.a.p. shouldnt be more than 1-2 hours of work if you know x-cart. Please only bid if you can provide the work today.

This is a very small project.
I have a custom made script that shows orders with quantities purchased and attributes per product purchased. One of the queries (I know exactly which one) is causing the page to load very slowly because it take the query very long time to complete.
I tried indexing one of the keys from that query in the db, which improved the speed a lot, but it is still very slow.I am very novice with optimizing mysql queries and mysql db and looking for an expert to optimize this one. I am not sure if it is possible to speed it up at all, but if it is possible to make it load in a few seconds – it shouldn’t take more than 1 hour work if you are an expert.