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

It sounds like what you're attempting to implement is something known as caching - and in performance cases, is generally(although not always) a good idea.

One thing you will need to be careful about is what comes back from the query - if you are caching a query that uses ID=1 as an argument and the data has changed, your cache will be invalid - and you'll need to be careful about that.

You might want to take a look at this article on caching for some tips on how to implement it.

Wait... You want to use flat files to make your code go FASTER? databases are much faster.

Flat Files are used as the cache output, querying a DB has a lot of overhead, takes resources and time, if the page has already been cached, then all you have to do is dump the output to screen.

I would recommend not making that claim unless you have a lot of benchmarks to back it up with.