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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.