Received: from facteur.in.grolier.fr (facteur.in.grolier.fr [194.117.196.5])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA83586
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 13 Jul 1999 09:14:44 -0400 (EDT)
	(envelope-from mheng@hachette-multimedia.fr)
Received: from eng (mheng.in.grolier.fr [194.117.198.178])
	by facteur.in.grolier.fr (8.9.3/8.9.3) with SMTP id PAA12879
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 13 Jul 1999 15:14:39 +0200 (MET DST)
Message-ID: <001501becd32$1bf8c660$b2c675c2@in.grolier.fr>
From: "Ming-Hung Eng" <mheng@hachette-multimedia.fr>
To: <pgsql-interfaces@postgreSQL.org>
Subject: ODBC Performance
Date: Tue, 13 Jul 1999 15:17:50 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

Hi

I want to copy a content of a Access table to a Postgres attached table via
ODBC.
There are 104000 entries.

The problem is the operation take more than 3 hours !!!

Do someone know why and what's wrong for me.

Thanks!!