The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We have a web application that displays graphs and data based on information stored in a mysql database. Those are SELECT queries that can get quite complex in some cases.
The response time varies and sometimes gets to several seconds. We'd like to optimize this drastically, and cut it down to under 1 second for the query response, at least for the main queries in the system.
We are open to suggestions both in the mysql configuration and in modifying/optimizing the queries themselves, but we would like to accomplish this without upgrading the hardware (it is a Dell R200 with 4GB RAM)
The UI is written in Perl.
The project will be declared successful if all (or at least all frequent) queries take less than 1 second to complete while a single user is logged in the system.
Sign in or Register to see more