save mysql result set in file

[muster_1978]

Hi!!!

I think i am the first person in this world who has this requirement.

I am working on an existing web application built in php/mysql.

This application has been around for several years and in due course of

time...its database has increased manifold and due to which it has

slowed down subsequently.

It has a function called as executeSql($query) which takes a mysql

query as an argument and returns the resultset obtained by executing

the mysql_query() function after executing the query.

Now i need to cache this result set returned from mysql_query()

function so as to be saved in a flat file and hence later on if i get

the same identical query to be executed..i will read this saved file

and return the result set so that i didn't need to make much changes in

this whole bulky code.

I have searched a lot on the web but to no luck till now 🙁 .

If anyone has any solution to this...please elaborate.

Please don't suggest any other alternative as this is exactly what i

want.

Thanks in advance..

Muster

[Piranha]

Ok, I'll not suggest any other alternative. But there are a few issues that you should be aware of:

1. How do you know if it is the exact same query?

2. How often is the exact same query executed?

3. How do you handle it when people are adding something to the database, will you return the old result set from the file?

4. You say "I think i am the first person in this world who has this requirement." It may well be since this is not a good solution. There are better solutions, but since you don't want any other solution I won't suggest any.

Sorry for the straight answer, I just think you have to think about the above.