Find Jobs
Hire Freelancers

Speed up mySQL database table with 11,000,000 rows

$30-250 USD

Completed
Posted about 9 years ago

$30-250 USD

Paid on delivery
No php knowledge needed. There is a table of 11,000,000 which has been slowed down for no reason (result given in 20 to 100 seconds). The table was working fine when I had 10,000 row. When I added the 11,000,000 all the crashing came. The table is indexed, you need to find a way to speed it up. Fast work & reply is needed. If you're slow don't bid.
Project ID: 6985317

About the project

12 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello As far as I can tell, the indexes in your table are not properly done or used. I need to identify the queries that are performed against that table, to possibly also change a bit the code and to optimize the indexes and their use so that it performs faster. I might also need to fine tune the mysql service on your server, if you have a dedicated server with root access. Regards, Dragos
$133 USD in 1 day
4.7 (76 reviews)
5.8
5.8
12 freelancers are bidding on average $125 USD for this job
User Avatar
A proposal has not yet been provided
$222 USD in 3 days
5.0 (303 reviews)
6.9
6.9
User Avatar
Hi! My name is Eugene. I'm mysql expert. I can handle your request. If you are interested please contact me and we will discuss details. Thank you.
$155 USD in 3 days
5.0 (10 reviews)
5.0
5.0
User Avatar
I am Database developer, have years of experience working with MySQL/ SQL and oracle. I can provide you a quality database in less time. Lets discuss.
$140 USD in 3 days
4.9 (7 reviews)
3.7
3.7
User Avatar
Just create an index on field on which you are selecting your records. Please reply for more discussion. Thanks
$30 USD in 3 days
4.9 (10 reviews)
3.4
3.4
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
5.0 (6 reviews)
2.9
2.9
User Avatar
6+ years experience in Linux Server Administration, extensive experience in installing, configuring: APF or CSF Firewall Apache & MySQL optimization MySQL optimization Database issues, backup and repair DNS configuration issues Load balancing PHP configuration, upgrades, and site errors Security lock down Disaster recovery Seamless Server migrations Proactive Server Monitoring Guaranteed Uptime Installing and configure new servers Firewall Installation and configuration Security Audit and Server Hardening Securing and Upgrading of SSH Server Installation of third party software and scripts LightSpeed and nginx Installation & configuration Kernel updates Exim tweaks – spam source detection and prevention Malware removal Plugin installation and configuration Backup configuration using either the internal control panel features, custom backup, rsync, or service such as R1Soft Failing services Disk space issues Fffmpeg and video Ttools And much more.
$111 USD in 3 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hi georgechalhoub, We have 20+ skilled mobile apps & Web development team, so please give few minutes for technical discussion of your requirement. Dedicated resource with full time availability to your project with Skype & email reporting with prompt response. Waiting for your reply & chance for further discussion.
$147 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, you have wrong query which maybe is doing to many joins. Can you give more detaials about query you are executing and some table schema? Best regards, Michal
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am having 15 years of experience in the field on Software development. I am associated with Emilia Technologies. I am having strong command on MYSQL and can handle the complex problems related to database. We have created many desktop and web based application along with there database and got the excellent response from the client. We are comfortable in solving your issues. Looking forward to hear from you. Thanks and Regards Emilia team
$210 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of LEBANON
Hadath, Lebanon
5.0
52
Payment method verified
Member since Mar 16, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.