I use a standalone connection pooling for Postgresql in some cases. It is faster and more efficient than doing full connects to Postgresql directly in each request.
https://www.pgbouncer.org/ Arndt. Am Di., 21. Nov. 2023 um 16:14 Uhr schrieb Eldav <[email protected]>: > Thank you Jonathan, > > after asking my question, I did more googling and found this : > > https://docs.sqlalchemy.org/en/20/core/pooling.html#pooling-multiprocessing > > It does mention Engine.dispose :) I tried their solution #4, which seemed > to be the one which fit best in my code. But somehow I feel it isn't quite > satisfactory, I see a lot of connects / checkout, which seems inelegant and > maybe bad for performance. > > Laurent. > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/pylons-discuss/e22c60a5-978f-4204-81a6-c2c64b26475bn%40googlegroups.com > <https://groups.google.com/d/msgid/pylons-discuss/e22c60a5-978f-4204-81a6-c2c64b26475bn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- ---------------------------------------------------------------------------------------------- nive.co <http://www.nive.co/> Arndt Droullier Tel 0221-2725782 Nive GmbH, Händelstr. 26, Köln, Germany -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/CAJYR-0NPoXCDu_oTG%3DLNaugF9uunUwGXdRswSCz_X0XvhkG%3D_w%40mail.gmail.com.
