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

[Michael Van Canneyt]

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.

Michael.