Optimize Queries to speed up site

Completed Posted May 4, 2015 Paid on delivery
Completed Paid on delivery

I have a website called funpoll.com. On the site you can answer different questions. Once you've answered (clicked on an answer) it then logs your answer (via mysql database query) and then loads a result page for that particular question. When loading the results page it usually takes about 1.5 seconds to load, as you can see. When the site gets a lot of traffic that number can go up to around 10 seconds. I need someone to optimize the queries so the load time is <0.5 seconds.

Apache JavaScript MySQL PHP Website Testing

Project ID: #7603449

About the project

26 proposals Remote project Active May 4, 2015

Awarded to:

TakeReal

Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. I can help you as SQL guru to speed up slow SQL. This is list of similar projects, successfully completed by me: 1. "MySQL Database Tuning" More

$50 USD in 1 day
(2141 Reviews)
8.3

26 freelancers are bidding on average $142 for this job

synapcs

Hey, I hope you are doing great and having a nice weekend. I have gone through your job posting and I have the expertise to optimize the website. I can work on your website and get remove all unwanted codes and o More

$210 USD in 2 days
(255 Reviews)
9.6
fastworkontime1

Hi There, I am ready to start work immediately. >>> I will completely optimized your website code so that it can be as short as possible with exact features and functionality as I am experienced developers. As W More

$180 USD in 3 days
(973 Reviews)
8.8
rajeshsonisl

Hello! With 98% to 99% completion rate, 800+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page [login to view URL] More

$147 USD in 1 day
(1095 Reviews)
8.9
SourceBurner

Just please provide me with ftp/db access and you can consider all the mysql query issues fixed including the database indexes if inappropriate. Best Regards, Viktor

$50 USD in 1 day
(140 Reviews)
5.8
sawyerrken

Hello, This is a possible fix. I will like to see the php files that handle the result processing. About Me ======== A web developer with vast experience in xHTML, CSS, PHP (procedural and OOP) & MySQL and Javasc More

$70 USD in 1 day
(35 Reviews)
5.4
gysyssl

hi. can be done. i propose following steps: 1. complex analyzing web site loading 2. rewriting/modernization php/mysql queries and db connection 3. and for final and guaranteed effect, i propose to make caching on More

$45 USD in 2 days
(40 Reviews)
5.3
remotemysqldba

Hey, I am an expert MySQL DBA and an optimization expert. I have a core knowledge on MySQL and its internals. I have very good command over MySQL query optimization too. I am a MySQL tech speaker and a blogger too. More

$133 USD in 3 days
(24 Reviews)
5.2
bhuasri876

Hello, I visited the reference website , it is based on technology PHP . I have understood your requirement but can you please share the Cpanel credentials so that I can have access to the database , files and folde More

$263 USD in 3 days
(26 Reviews)
5.9
splsh

A proposal has not yet been provided

$225 USD in 7 days
(13 Reviews)
4.7
bistanil98

Need to discuss this in detail,please tell me how we can start the discussion on this requirement. We have a team of 34 professionals,they have more than 11 year of experience, expertise in php/mysql and their MVC f More

$150 USD in 5 days
(39 Reviews)
6.8
reachgz

Hi, that seems fairly simple, at my current job we handle a lot of sales per minute, some of the tables we manage have over 100 million records and I have to make some really optimized queries to them. I think I can ha More

$80 USD in 3 days
(0 Reviews)
0.0