Received: from degroens.oracom.com (degroens.oracom.com [63.238.138.68]) by postgresql.org (Postfix) with SMTP id 3FCBE475858 for ; Thu, 21 Feb 2002 11:25:54 -0500 (EST) Received: (qmail 11650 invoked from network); 21 Feb 2002 10:16:16 -0000 Received: from unknown (HELO catamount) (192.168.253.253) by 192.168.253.2 with SMTP; 21 Feb 2002 10:16:16 -0000 Message-ID: <006901c1baf5$3bce6360$4d00a8c0@catamount> From: "Glenn MacGregor" To: Subject: Help with many updates Date: Thu, 21 Feb 2002 11:31:37 -0500 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.50.4133.2400 X-Mimeole: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200202/273 X-Sequence-Number: 6696 What is the preferred way to do many updates. Right now I am just doing each row at a time, is there a better way? I have about 1000 or so and it takes a good 45 seconds Thanks