On Fri, Mar 19, 2010 at 18:44, Rick Roen <r...@lakevalleyseed.com> wrote: > Are there any generalized guidelines for these values and do I need pooling
Best is to have pooling turned on and if you know (like the form is loaded), that there will be no activity for some time (i.e. waiting for user's input), clean the pool. > at all? I don’t know if the database server is affected by having 300 > connections open (30 users * min pool of 10), but it seems to have little That's not exact. The minimum is number of connections kept if created (more). If your application uses only one thread and you're not using two connections in the same time, there will be only one connection. Hence there will be 30 connections on server and only for lifetime specified. > effect. I would just rather have it set “properly” if that concept exists. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider