MySQL expert to optimise a single table and query.
- or -
Post a project like this£60/hr(approx. $75/hr)
- Posted:
- Proposals: 16
- Remote
- #3075992
- Expired
Description
Experience Level: Expert
Looking for a MySQL database expert/architect only
I have a table which can contain as much as 133 million rows of INT data. I am looking for someone who can assist in optimising the table, but also looking at ways that we can improve the query to run better. Maybe there is a better way for us to store and query this data altogether?
The query is quite big, but a lot of it is replicated sub queries which we generate and run from PHP. I have attached an example which I believe currently takes around 30 seconds to run on 16 million rows.
Happy to send a copy of the database dump.
I have a table which can contain as much as 133 million rows of INT data. I am looking for someone who can assist in optimising the table, but also looking at ways that we can improve the query to run better. Maybe there is a better way for us to store and query this data altogether?
The query is quite big, but a lot of it is replicated sub queries which we generate and run from PHP. I have attached an example which I believe currently takes around 30 seconds to run on 16 million rows.
Happy to send a copy of the database dump.
WEBFWD LTD
100% (37)Projects Completed
41
Freelancers worked with
39
Projects awarded
31%
Last project
14 Sep 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi there,
Are you still looking for a DB expert please?
Regards,
Shan
958613
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies