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

Michael Van Canneyt michael at freepascal.org
Fri Aug 7 15:50:01 CEST 2009

On Fri, 7 Aug 2009, Graeme Geldenhuys wrote:

> Michael Van Canneyt wrote:
>> Most likely the SqlDB+PostgreSQL components.
> :-(  I'll try and do other tests maybe via different components to see
> if there is really such a huge speed penalty on my PostgreSQL setup. I
> have heard that the default PostgreSQL installation is not tuned for
> performance - but those where slightly old posts I found on the internet.
> A magnitude of x15 slower is rather huge for a default install! Hence
> the reason I thought I would ask here about the SqlDB components.
>> My guess is that for each separate transaction component, a new
>> connection is set up. So if you create/free a lot of transaction
> My test suite only creates one DB connection for all db related tests. Test 
> hierarchy is as follows.

The connection is not relevant.

You can have 1 connection component and 15 transaction components.

This will result in 15 (!) connections to the postgresql database, not 1.


More information about the fpc-pascal mailing list