Received: from primaire.intelcom.fr (primaire.intelcom.fr [194.250.33.1]) by hub.org (8.10.1/8.10.1) with ESMTP id e7H8k7m10167; Thu, 17 Aug 2000 04:46:07 -0400 (EDT) Received: from volvo.intelcom.fr ([192.168.160.20]) by primaire.intelcom.fr (8.8.8+Sun/8.8.8) with SMTP id KAA16272; Thu, 17 Aug 2000 10:45:47 +0200 (MET DST) Received: from intelcom.fr by volvo.intelcom.fr (SMI-8.6/SMI-SVR4) id KAA07812; Thu, 17 Aug 2000 10:45:37 +0200 Message-ID: <399BA631.CD5FD67E@intelcom.fr> Date: Thu, 17 Aug 2000 10:45:37 +0200 From: Jerome Raupach X-Mailer: Mozilla 4.74 [en] (X11; U; SunOS 5.5 sun4d) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org, pgsql-general@postgresql.org Subject: optimization in C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/374 in C, I work on a database (4 table). COPY FROM file ; SELECT, INSERT, UPDATE, DELETE for a result in the last table. COPY TO file ; in the file, are stored 10000 informations. -> It's slowly !!! Can you help me for optimization this? I didn't use Oid, trigger and function SQL. Thanks. Jerome.