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.

Habilidades: MySQL, Arquitetura de software

Veja mais: 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

Acerca do Empregador:
( 1 comentário ) Bratislava, Slovakia

ID do Projeto: #5120534

Concedido a:


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 Mais

€111 EUR em 3 dias
(58 Comentários)

38 freelancers are bidding on average €122 for this job


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 Mais

€263 EUR in 5 dias
(849 Comentários)

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 Mais

€150 EUR em 1 dia
(88 Comentários)

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 dias
(125 Comentários)

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 Mais

€100 EUR in 3 dias
(87 Comentários)

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 Mais

€210 EUR in 4 dias
(36 Comentários)

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 Mais

€105 EUR in 3 dias
(18 Comentários)

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 Mais

€105 EUR em 1 dia
(51 Comentários)

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 dias
(23 Comentários)

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

€147 EUR in 3 dias
(7 Comentários)

A proposal has not yet been provided

€200 EUR in 7 dias
(2 Comentários)

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 Mais

€125 EUR in 2 dias
(18 Comentários)

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 dias
(6 Comentários)

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 Mais

€80 EUR in 3 dias
(6 Comentários)

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:

€76 EUR em 1 dia
(5 Comentários)

Aucune proposition n'a encore été fournie.

€210 EUR in 3 dias
(10 Comentários)

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 Mais

€155 EUR in 3 dias
(10 Comentários)

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 Mais

€141 EUR in 3 dias
(3 Comentários)

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 dias
(3 Comentários)

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 dias
(2 Comentários)

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

€155 EUR in 3 dias
(3 Comentários)