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 JAA89311 for ; Mon, 3 May 1999 09:57:31 -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 JAA24616; Mon, 3 May 1999 09:02:12 -0500 Message-ID: <06da01be956e$a58ee860$8355e5ce@base2inc.com> From: "Frank Morton" To: , "Herouth Maoz" Subject: Re: [SQL] Slow Inserts Again Date: Mon, 3 May 1999 09:10: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 >> I have tried many combinations of things to speed this >> up as you all have suggested. I have had no success >> using "copy" at all because of problems with quotes >> and other punctuation in the data. > >I must tell you, this doesn't sound reasonable to me. It's usually very >easy, if you already have a program that writes down the fields, to make >sure it scans the contents thereof and adds a backslash before each tab, >newline and backslash in every one of the fields. Is there a doc somewhere about what characters are treated in some special way when doing a copy?