[thelist] quick sql performance question

[Anthony Baratta]

If you are using MS SQL, you might want to consider re-formatting the insert data into an XML document and bulk insert the data via the XML option in the DB. 

If you want more info I can post an example.

-----Original message-----
From: "Chris Anderson" Chris at activeide.com
Date: Thu, 20 Sep 2007 11:11:20 -0700
To: thelist at lists.evolt.org
Subject: Re: [thelist] quick sql performance question

> The first would be quicker overall (except with semi-colons)
> But faster still would be a BULK INSERT
> 
> 
> -----Original Message-----
> From: "Brian Cummiskey"<brian at hondaswap.com>
> Sent: 20/09/07 19:00:18
> To: "thelist at lists.evolt.org"<thelist at lists.evolt.org>
> Subject: [thelist] quick sql performance question
> 
> which is the better method?
> 
> I have about 2000 inserts to do which comes in from a web service.
>