Enhance MySQL select

Completed Posted Nov 12, 2013 Paid on delivery
Completed Paid on delivery

Need to enhance (speed up) complicated MySQL select from many tables in database. If neccessary, suggest also table structure remake. Actually there are 12k rows in database and it will raise in future. The biggest problem is when making SUM from some cols, selecting time is about 15 seconds.

I will send you all tables structure and full select.

MySQL Software Architecture

Project ID: #5120534

About the project

37 proposals Remote project Active Nov 16, 2013

Awarded to:

danale72

Hi I can do this task for you. Several sub-tasks are possible: - optimizing query - optimizing tables structure - setting up proper indexes. - optimizing server settings I have quite good experience in those More

€111 EUR in 3 days
(81 Reviews)
5.9

37 freelancers are bidding on average €122 for this job

hits

We are a team of designers and developers with expertise and experience in Web designing, HTML, CSS, PHP, AJAX, JQuery, Wordpress and MySql. We have developed many complex and extensive custom sites of varied extent More

€263 EUR in 5 days
(820 Reviews)
8.9
gopalvora

Hi ready to start i had more than 5 year experience in the php , mysql , jquery etc.. so let me know your view Thanks

€103 EUR in 5 days
(293 Reviews)
7.9
CodeAmbassador

Hi, My name is Janos, I'm from Hungary and would like to help you on this. Assuming you have skype and teamviewer we can discuss the details while I'm connected to your PC and I'll talk your through what is being d More

€150 EUR in 1 day
(85 Reviews)
7.5
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

€134 EUR in 5 days
(253 Reviews)
7.5
theincredible

Hi Sir, I am expert in SQL optimization, and I will be happy to do this task for you. I can do it within the next 24 hours. Thanks and regards, Yasser

€111 EUR in 0 days
(73 Reviews)
7.0
amusto

Add indexes in your tables. PLease visit my profile Regards Armando ########################################################

€147 EUR in 3 days
(48 Reviews)
7.1
Mezh

Hello! I'll be happy to help you with your project, please read and answer. Yes, obviously your select-query is bad, because table with 12k records - it's very very small table, and 15 seconds to process one reques More

€105 EUR in 3 days
(27 Reviews)
5.6
drailean

Hi, please send me the db structure and the queries you're running there against those tables ... it's VERY much to have a 15 seconds query on a 12k rowset, I have some 4mil+ records in a table and sum() takes 1 second More

€105 EUR in 1 day
(89 Reviews)
6.1
envisionops

Hello, I understand the problem you faced. I have more than 8 years of experience in IT-Programming and creating websites. I have best ratings on FL and good completion ratio. above all, I am reasonable when it comes More

€100 EUR in 3 days
(96 Reviews)
5.7
GisOnline

Sir! I'm experienced on this before and I may help you. I will tell you detail in the private message I'm very happy if you may check my awesome feedback here: https://www.freelancer.com/u/gisonline.html

€76 EUR in 1 day
(33 Reviews)
5.4
sdgcode

Hi , I'm ready for your project send me your tables and I will make changes and I will upload on my server to show you how work . Regards

€55 EUR in 0 days
(17 Reviews)
5.3
netquart

Hi, We are a team of experienced developers we have expertise in database designing , optimizing. after reading your details the database would be optimized as first of all we will check the structure of databa More

€155 EUR in 3 days
(21 Reviews)
4.9
SergeScz

Hello show me the queryn and data model and i will optimalize it for you. I can start immediately. I have large experience with "big-data"

€70 EUR in 3 days
(4 Reviews)
4.8
elboukharimu

Aucune proposition n'a encore été fournie.

€210 EUR in 3 days
(26 Reviews)
5.0
esafeguard

Hi. I'm a MySQL and PHP programmer. I will suggest optimization changes to the structure and queries. Please provide a more detailed description of the database. Regards.

€111 EUR in 3 days
(7 Reviews)
4.4
AccuPro

Hi, I see there are people bidding much lower, but they do not have any badges to demonstrate their skills. If you send me the SQL and the structure right away, and I feel I could do it for a lower price, I'll do it f More

€80 EUR in 3 days
(7 Reviews)
3.8
oobretenov

I have experience in DB design and MySql . I could help you with this project. . More

€155 EUR in 3 days
(7 Reviews)
3.3
webviet247

Đề xuất vẫn chưa được gửi

€90 EUR in 5 days
(2 Reviews)
3.2
tsalmark

Thank you for considering my proposal. I work with large data sets in mysql both for statistical research and web applications. I have on numerous occasions had to optimize sql queries. a 15 second run for a few More

€141 EUR in 3 days
(4 Reviews)
3.3
modestasmockus

I am experienced Oracle DBA and developer. I can analyse your selects ant update them without problem. Looking for more details. Accept my proposal and you will not complain.

€111 EUR in 3 days
(2 Reviews)
1.3