Re: Another (probably dumb) question - IDS SQL results cache

Don't forget that your buffer cache pool would have been populated as well as any result cache. It could be that the performance boost is not so much from using result cache, but from the fact that the buffer was pre-loaded from the prior query. M.P. malc_p@btinternet.com wrote: > I'm trying a couple of performance tests on simple queries; for > example, setting/unsetting IFX_FLAT_UCSQ. > So, I set up an SQL and run something like: > > timex dbaccess my_db query1 > > and get a run time of, say 4.5 seconds. Then I set IFX_FLAT_UCSQ and > get 1.17 seconds, i.e. a good result. > To confirm, I unset IFX_FLAT_UCSQ and run the query again; and get 1.18 > seconds. > Doh! The query hasn't changed so the result set is still in cache from > the previous run. > In essence, this means that I can't prove it was the setting/unsetting > of IFX_FLAT_UCSQ which caused the improved query time. > > So my question is, is there a way to clear the cache or do I have to > restart the server in between tests? > > (Bearing in mind that I'm probably oversimplifying and it's 10-1 on > that I've missed something simple anyway and it's Monday so I've got my > "Mr. Dumb" hat on.)