Thread: Import Performance

Import Performance

From

elwood@agouros.de (Konstantinos Agouros)

Date:

07 February 2001, 18:10:29

Hi,

after waiting for imports using perl dbi/prepared-statement/inserts I came
across the idea to first create a ;-separated file and then use the copy-
command. Should this be faster after all?

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

Re: Import Performance

From

"Anthony E . Greene"

Date:

08 February 2001, 06:03:56

On Wed, 07 Feb 2001 15:09:07 Konstantinos Agouros wrote:
>after waiting for imports using perl dbi/prepared-statement/inserts I came
>across the idea to first create a ;-separated file and then use the copy-
>command. Should this be faster after all?

Yes. Just remember to drop indexes before the import and re-add them
afterward.

Tony
--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>