PGLoader performance

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
piopio
Posts: 17
Joined: Tue 22 Nov 2011 23:41

PGLoader performance

Post by piopio » Sun 03 Jun 2012 14:49

Hello,

How much is the performance improvement if using PGLoader instead of a normal SQL Insert ?

I know, this can vary but I'd like to have an esteem.

Many thanks


Pio Pio

ROD
Devart Team
Posts: 23
Joined: Mon 07 May 2012 09:09

Re: PGLoader performance

Post by ROD » Tue 05 Jun 2012 11:24

Hello Pio Pio

Timing performance of the usual records insert to the table via "insert" is much less than the one via PgLoader, in some cases in 100 times.

You can ensure yourself, for quickness, using the demo sample
...\Demos\Win32\PgDacDemo\PgDacDemo.dpr
the Loader item.

Post Reply