Re: slow insert a lot of row from table adapter to sql table, improve?
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Mon, 4 Feb 2008 07:15:58 -0500
alex wrote:
I have to insert a lot of rows from a tableadapter to a sql table.I think this is a dotnet question but I'm not sure because I've never heard
The operation is slow because table adptert send a single insert
command for each row.
Is there any way to have it with only one batch command? Or a faster
solution?
of a "tableadapter". If it is a dotnet question, then:
There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet.
If you are using SQL Server, then you have all sorts of bulk insert options
which you can read about in BOL.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Prev by Date: Re: 32-bit Application using ADO under 64-bit OS (Windows Server 2003)
- Next by Date: Re: DateTime, variants and double
- Previous by thread: Re: Newbie
- Next by thread: Re: DateTime, variants and double
- Index(es):
Relevant Pages
|
|
