Received: from www.base2inc.com (IDENT:root@www.base2inc.com [204.117.190.140]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA85904 for ; Mon, 3 May 1999 09:37:54 -0400 (EDT) (envelope-from fmorton@base2inc.com) Received: from tesla (tesla.base2inc.com [206.229.85.131]) by www.base2inc.com (8.8.7/8.8.7) with SMTP id IAA24463; Mon, 3 May 1999 08:42:28 -0500 Message-ID: <06c001be956b$e35db0c0$8355e5ce@base2inc.com> From: "Frank Morton" To: "Vadim Mikheev" Cc: Subject: Re: [SQL] Slow Inserts Again Date: Mon, 3 May 1999 08:50:21 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 >> This last attempt, I bracket each insert statement with > ^^^^^^^^^^^^^^^^^^^^^ >> "begin;" and "end;". > >Why _each_? >Enclose ALL statements by begin; & end; to insert ALL data >in SINGLE transaction: This was suggested by someone on the list so that all 150,000 inserts would not be treated as one large transaction. Like I said before, I have tried all suggestions without success.