Make my sql run faster. - open to bidding

Dear Sir, I have read your Project Description & very much interested to work with you on this project but do you have more detailed requirements, some reference/example website URL or can you drop me a message thru' Freelancer PMB to discuss requirements? Just so you know, our current bid is just a placeholder to submit the proposal & start our communication. Look forward to hearing from you. Regards, YK LEADconcept

----------------------------------------------------------Please Consider on My BID---------------------------------------------------Dear Sir/Madam, We are already read your project description & fully understand this project for you. Also I have solid experienced professional in-house team of designers, developers and coders. We are offering best price in this market & providing best quality of work for you. Please check your PMB for more details & award me for this project. ~~~~~~~~~~~~~~~~~Few reasons to select us as a service provide~~~~1. Post delivery free bug fixing support.------- 2. Industry standard modern design.------- 3. Secure coding SQL injection and XSS (cross site scripting),------- 4. Well documented code.------- 5. Regular work update. ~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~ Thanks with Regards

Hello. Please give more detailed description of the project. I've got really very big expirience is php/mysql software development and sure will solve your task quickly with the best quality

Hello, We have gone through the scope of work and would be happy to provide complete solution on this and future support also if required. Scope of work includes - - Optimizing the DB and site performance - We will use indexing where required - We will optimize complex queries to extract only relevant information Let's take it to the next step and start on this ASAP. Thanks, Techmart Team

Hello, I've several years of experience working with MySQL and queries I'll do my best to optimice the query. However still couild happen that your server is slow and all the proper optimization measures has been taken by the previous coder. On this case I should be able to let you know right after start working. Just keep it in mind Regards Marcos

Hello Please consider me as a candidate for the project. See my projects history for references. As a start point I would like to have slow query log. Note that Mysql was designed for relatively simple queries so I might need to change DB schema to make a query simpler. All the best Alexei

Hello, MySQL should be able to handle 100,000 results (and even millions) with ease. Do you have any example mysql statements being made on the website for me to check out? Is there any other tables than the one? Can I see the mysql schema (excel file)? Looking at your website, it appears it is generating totals. If it's doing this per month for each row, that's a lot of trips to the mysql database! It may be better to precalculate these values, and have a script run monthly to generate the totals if it is working how I believe it is. Thank you, and I look forward for the chance to work with you!

Hallo, I have several years of experience in programming webbased applications with PHP and a MySQL backend. Im sure that i can help you speeding up your site. If you have any questions please don't hisetate to contact me at kontakt (at) smart-websolutions (dot) net Kind greats Martin Seifert smart-websolutions

i can help u in this project please contact me for further details.

More than tuning the sql you may need to add indexes in the DB. Please identify the most used columns in the "where" clause of the sql and add index for that. Probably this will solve your performance issue.