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
Expert in php yii cakephp codeigniter laravel html5 scraping website node.js, reactjs python aws cloud machine learning data Analyst css3 javascript perl Api mysql json angular moodle wordpress
Little Elm
Web Applications (PHP | Laravel | Go | MySQL | Javascript | jQuery | React), Mobile Apps (React Native | Android), Microservices, System Analysis, DBs, Data Science, Machine Learning, Deep Learning
Bay Minette
♛ No. 1 ♛ UK's Professional Web Development , Web Designing, Magento , Shopify, WordPress , API Integration, Full-Stack Ruby on Rails Developer,Senior Front-End Developer (AngularJS / Node.js)
Chandigarh
Full Stack Developer | Laravel | Angular |React JS| CodeIgniter | WordPress | Web And APP Designing | Mobile Application Development | Digital Marketing
Ahmedabad
Senior Developer / Solution Architect / Database Expert / System Integration specialist
Colombo
6648761988269210119045680645815497692511700051300089174258630846833284930
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