[fpc-pascal] SqlDB connection speed to Firebird vs PostgreSQL

[black dog]

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 <graemeg at 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 -
>