slow remote queries?
i have a lot of table from a remote mysql database. and the first time you select anything from a given table it takes a good 20s before the data shows up. i suppose that by the second time they are cached as they are as fast as you would expect them to be if there where local.
is there a way to auto cash everything? or is there a better approach to this?