Re: How to invalidate informix' db-cache

In article <3649C80E.7F9@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Markus Pfadenhauer wrote: >> >> hi all, >> >> is it possible to invalide the whole internal database cache. >> By now I create some dummy tables and do a relationscan on them but >> this is not the very best solution. > >There is no way to do this except to bounce the server. However, why >do you want to do this? BTW what aspects of the cache do you want to >invalidate, Informix actually has several caches: data buffers, data >dictionary cache, stored procedure cache, etc. > I suspect for performance tuning. i.e. to be able to start the 2nd test with a 'cold' cache i.e. not containing data from the 1st performance test... >Art S. Kagel -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care