Hi Everybody!!!

I have done loads & loads of searching on the net but couldn't find a solution for this.

I have a large bulky code of an application that has been around for years. It is built in PHP/MySql. Now the problem is that as the user database increased...the application slowed down. Now i have been assigned the task to find tune the application to make it faster.

I have parsed through the code and found that there is a function ExecuteSql which takes a query as an argument and then executes that query using mysql_query() function and then returns the result set obtained by running mysql_query().

What i m planning is if i can get the exact structure of the mysql resultset that is returned by executing the mysql_query() function...then i will save that in a flat file. Now whenever i encounter the same identical query again & again..i won't query the database server, instead i will load the result set saved in the flat file and then i will return that result set. In this way i hope that i will b able to make the application faster without doing much changes in this huge bulky code.

Can anybody help me on this?

Would greatly appreciate any help.

Thanks
Muster

What you want to do is caching.

If you look on google, there are some good tutorials on creating a cache engine for your php scripts. Basically, when a user visits a page, if it is in the cache and not too old, instead of querying the database or anything it will use the cache.

Also, I would recommend changing to the mysqli driver.