Cache SQL querry

[Jack]

Is it a good idea to cache the SQL queries?
Like:
SELECT SQL_CACHE id, name FROM customer;

[djn]

Not really. On a shared server the query cache would be quickly maxed out by all the accounts (assuming it it enabled at all) antytime traffic grows. Take a look at AdoDB (http://adodb.sourceforge.net/), it might be what you need...