Re: bug in zcatalog queryplan causing very slow first query after startup
Gil Forcada Codinachs <[email protected]>
| Newsgroups | gmane.comp.web.zope.plone.devel |
|---|---|
| Message-ID | <CAKSaQ195hDUOp2YHG=zU8yHP7Ny4u7GL7dtdz8kUepOi9XBd4w@mail.gmail.com> |
2013/10/18 Hanno Schlichting <[email protected]> > > With all that said, maintaining query plans across instance restarts has > much > less value than one would assume. The best one can do is to create some > warm-up process to prefill the connection cache before allowing any newly > started instance to serve web traffic. > > Hope this is remotely comprehensible :-) > Hanno > Hi all, Thanks for sharing all this wisdom! Actually at der Freitag we use this script[1] to warmup any worker that is restarted due to too much memory consumption or due to new deployment version. I hope it helps someone! Oh, and credits go to Timo as he did the original version, I just messed with it from time to time. Cheers, Gil Forcada [1] https://gist.github.com/gforcada/7040082 ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk _______________________________________________ Plone-developers mailing list Plone-developers-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/plone-developers