The usual way I deal with postgres - in java - is to have a connection pool. I believe this is more or less standard in pg for performance and it does work extremely well. I don't i'm afraid, have a pascal db connection pool.
bd On Fri, 07 Aug 2009 10:42:03 +0200 Graeme Geldenhuys <grae...@opensoft.homeip.net> wrote: > Hi, > > I'm using SqlDB (via tiOPF framework) in our applications. Our > software has a lot of db and non-db unit tests. > > When I run a section of our db unit tests via SqlDB + Firebird, they > complete in about 6-7 seconds. When I run that exact same set of db > unit tests via SqlDB + PostgreSQL, they take about 70-90 seconds to > complete! > > Why is the connection to PostgreSQL so VERY slow? Is it the > SqlDB+PostgreSQL components or is it something I need to tune in the > PostgreSQL config settings? > > Sorry if this is a dumb question, by knowledge of PostgreSQL is very > limited (a week to be exact). > > > Regards, > - Graeme - > _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
