Find Jobs
Hire Freelancers

Database Expert Required to Improve SQL Response Time

$15-25 USD / hour

In Progress
Posted over 8 years ago

$15-25 USD / hour

We have a large database with around 4 million rows and SQL queries are taking around 18 seconds, whereas we know similar commands on other sites can return the same information in 2 seconds. We need someone who is an expert in databases to review our structure/coding and make the necessary changes.
Project ID: 8682205

About the project

17 proposals
Remote project
Active 8 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
17 freelancers are bidding on average $19 USD/hour for this job
User Avatar
A proposal has not yet been provided
$22 USD in 3 days
4.9 (139 reviews)
6.3
6.3
User Avatar
Hi, I am an expert in database tuning and optimization and developer with over 17 years of experience. I need to findout the possible bottleneck for this issue, though coding can only help out to know the SQL query it invoking, but real optimization can only be done at database level. I also like to know if query run slow at same rate all the time or it vary depending on user's load ? Please accept my bid and share me necessary information and credentials and I am ready to go. Thanks & Regards Sandeep Verma
$25 USD in 3 days
5.0 (28 reviews)
5.1
5.1
User Avatar
A proposal has not yet been provided
$20 USD in 10 days
5.0 (20 reviews)
4.6
4.6
User Avatar
Hi there, I'm a Linux sysadmin with 14 years of experience managing Linux servers and would love to help you with this project. I'd say that your slow queries are probably caused by missing indexes and parameters that can be tuned on /etc/my.cnf. Would be glad to help you. Best regards, Marco Ramos
$15 USD in 4 days
5.0 (21 reviews)
3.8
3.8
User Avatar
Hi, I am software engineer from Serbia. I can help you speed up SQL response times by changing SQL queries and making them better. I need to say that sometimes there is more things that impact processing. Is code that uses queries optimized, do you have queries on sql server or in code, etc. I can explain you what can be the problem and if we found it and then fix it then you will pay me. Nothing in advance just if we find the problem and fix it then we will finish the project. If you have any questions feel free to contact me. Regards, Mike.
$15 USD in 10 days
4.9 (4 reviews)
1.9
1.9
User Avatar
Im management big data transactions in sql, the coca cola company. =) i need acces to one database of develop, replica of the production "testing server" i need the scripts of the issues. and the acces to ports for query analizer. first need verify the complexity of the stores, and sintaxis the second point to verify is the perfomance of the consult and tables, indexes etc..
$15 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Iam working as database admin and java developper from past 65 years handling 6 crore of data every day handling 50000 queries per sec on every day handling almost billions of queries easily executing
$15 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am currently working on something similar on my day job. All day long, I create/debug SQL Stored Procs and try to enhance execution time. Hopefully, this will be my first project here at this site, and will aim to provide the best customer experience! Please do let me know if you have questions.
$16 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I 'm very good Database and query. Please give me opportunity to have this project, to make your data structure better and prove myself.
$15 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Larbert, United Kingdom
4.9
40
Payment method verified
Member since Jun 22, 2008

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.