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.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
