In Progress

Enhance MySQL select

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.

Skills: MySQL, Software Architecture

See more: select, mysql tables rows, rows cols, select select, mysql software, time table making software, time tables software, suggest select, mysql select, select suggest, mysql suggest, suggest mysql database, mysql select table, mysql speed, ajax php select mysql, form select mysql, php drop select mysql, mysql database speed, dropdown select mysql, eliminate duplicates select mysql php, odbc mysql user name char problem, ajax country state city drop select mysql, mysql select time, search select mysql, speed mysql

About the Employer:
( 1 review ) Bratislava, Slovakia

Project ID: #5120534

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
(58 Reviews)
5.5

38 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
(849 Reviews)
8.8
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
(88 Reviews)
7.5
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
(125 Reviews)
6.7
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
(87 Reviews)
5.5
expertcoder1vw

I'm an expert MySQL and database designer and developer and can optimize your queries for you. I will work with you to recommend optimum query and table re-structure if needed. Thanks for considering my bid. Be More

€210 EUR in 4 days
(36 Reviews)
5.4
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
(18 Reviews)
5.2
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
(51 Reviews)
5.0
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
(23 Reviews)
4.8
amusto

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

€147 EUR in 3 days
(7 Reviews)
4.7
rohanjshah

A proposal has not yet been provided

€200 EUR in 7 days
(2 Reviews)
4.7
eComOS

Hello activtrip, I have gone through your outsourced requirement "Enhance MySQL select" and have analyzed that I have right credentials (MySQL, Software Architecture) to execute your esteemed project. ===== Wh More

€125 EUR in 2 days
(18 Reviews)
4.2
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
(6 Reviews)
4.2
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
(6 Reviews)
4.0
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: [url removed, login to view]

€76 EUR in 1 day
(5 Reviews)
4.0
elboukharimu

Aucune proposition n'a encore été fournie.

€210 EUR in 3 days
(10 Reviews)
3.8
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
(10 Reviews)
3.6
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
(3 Reviews)
3.3
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
(3 Reviews)
3.1
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
(2 Reviews)
2.9
oobretenov

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

€155 EUR in 3 days
(3 Reviews)
2.2