[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