[thelist] quick sql performance question
Anthony Baratta
anthony at baratta.com
Thu Sep 20 15:08:38 CDT 2007
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.
>
More information about the thelist
mailing list