Re: What's the best way to open a recordset for insert only?
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 8 Apr 2008 15:03:46 -0400
Spencer wrote:
Just in case you were wondering, the application is now inserting
3000-4000 records in the test environment per tick of the progress
bar/call to BatchUpdate. Setting rs.ActiveConnection to Nothing
between batches doesn't seem to improve that significantly.
It shouldn't. What it should improve is the number of active connections
to your sql server while you are adding the records to your recordset.
It is always good to minimize those connections.
I guess another way to say this is: there is no need to be connected to
the sql server in batch update mode until you need to send the batch
updates to the database.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- References:
- What's the best way to open a recordset for insert only?
- From: Spencer
- Re: What's the best way to open a recordset for insert only?
- From: Bob Barrows [MVP]
- Re: What's the best way to open a recordset for insert only?
- From: Spencer
- What's the best way to open a recordset for insert only?
- Prev by Date: Re: What's the best way to open a recordset for insert only?
- Next by Date: Re: What's the best way to open a recordset for insert only?
- Previous by thread: Re: What's the best way to open a recordset for insert only?
- Next by thread: Re: What's the best way to open a recordset for insert only?
- Index(es):
Relevant Pages
|
|
