There are slow queries generated towards our magento database. The slow queries are being stacked up and thus overloading the server resources on our present server.
Unfortunately with the current configuration our website is no longer suitable for the hosting server we're on now and therefor the need of optimization. We need to optimize the magento applipication so that it has the lowest available cpu usage at any one time.
This is a very small project but there will be a good chance that you can get other projects either regular either with the hour if you do a good job.
The project is very urgent and has to be delivered asap.