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

Graeme Geldenhuys graemeg at opensoft.homeip.net
Fri Aug 7 10:42:03 CEST 2009


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).

   - Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal

More information about the fpc-pascal mailing list