Hi,

I'm working on a C# program for database I/O using System.Data.SqlClient.
My question is, if I have data stored in an array, is there a fast way to
import data from an array to a table (similar to BULK INSERT)? I'm using SQL
ommand 'INSERT INTO' to import data record by record but it is very slow when
the array is large.

Any suggestions would be appreciated.

Compiler: Visual .NET 2003
Database: SQL Server 2000
OS: Windows Server 2000

Jason,

"jason chern" wrote:
My experience is that INSERT into a small table without indexes is usually
pretty fast.
How large is the target table? Do you have a lot of indexes on it? If both
are true, and the number of rows to insert is very large, you could consider
creating a temp table without any indexes, loading into that, then using
INSERT...SELECT from the temp table into the permanent table. If there are
relatively a lot of rows to insert, then depending on the number of indexes,
you could consider dropping the indexes on the permanent table before the
INSERT...SELECT, then rebuilding them afterwards.

Regards,
Jonathan

Regards,
Jonathan

you can create a stored procedure that accepts
the values , and then fire the procedure in a loop
its fast !!



"jason chern" <jchern (AT) sivtec (DOT) com> wrote