Force caching in mysql

is there any way to enable it?

[Namaste]

Our site is going through some heavy traffic.

We have noticed that pages that are frequently visited are served quickly by MySQL through it's cache. P

Problem comes when users goto pages that are infrequently visited and MySQL needs to geneerate them for the 1st time.

Is there anyway to "run" these queries in advance and get MySQL to develop a cache of them?

[txbakers]

In version 5.0 (still in Beta) mySQL will support stored procedures which will in essence run quieries at the DB first making it faster.

If the queries you have now are slow, you might want to look into Indexes.