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 TAA72008 for ; Mon, 3 May 1999 19:47:29 -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 SAA28218; Mon, 3 May 1999 18:52:07 -0500 Message-ID: <07d001be95c1$119189d0$8355e5ce@base2inc.com> From: "Frank Morton" To: , Subject: Re: [SQL] Slow Inserts Again Date: Mon, 3 May 1999 19:00:06 -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 >Is it at all possible that the optimizer is responsible for this behaviour? >The reason I ask is that the fact that when the inserts start the optimizer is >working with a very small table, as the table grows larger the optimizer never >learns it because no VACUUM or VACUUM ANALYZE have been run. > >If this is indeed the problem, then running VACUUM after every 10,000 inserts >would solve the problem. Can I run a vacuum while inserts are still going?