I am working with some pretty convoluted queries that work very slowly the first time they’re called but perform fine on the second call. I am fairly certain that these differences are due to the caching. Can someone point me in a direction that would allow me to pre-cache the critical indexes?
- Re: [PERFORM] preloading indexes stuff
- Re: [PERFORM] preloading indexes Matt Clark
- Re: [PERFORM] preloading index... stuff