Re: ADO Performance question
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Thu, 27 Oct 2005 15:45:34 +0100
>>>
I am writing a code which is actually performing multiple inserts on a
table.
Currently I am combining all my insert queries and passing as command text
to ADO command object.
There is one more way by opening a recordset and call AddNew on recordset
multiple times and then batch update.
>>>
For what provider?
It makes a difference as the SQL Server Provider allows multiple commands
Also - do you have to check to see if row is already on table?
Stephen Howe
.
Relevant Pages
- RE: Form For Crosstab Query
... My next step is to place the query on a continuour form, and add a command ... FROM (TimeRecords INNER JOIN Staff ON TimeRecords.StaffID = Staff.StaffID) ... I would like to add an additional column that sums the multiple of each ... (microsoft.public.access.forms) - Re: Grouping Multiple Side by Side Columns
... "The command can't be performed with multiple sections ... "Bob I" wrote: ... sam wrote: ... (microsoft.public.excel) - Re: Bash commands: maybe they want to drive us crazy?
... Here is the man page SYNOPSIS for grep, ... be multiple files with /grep/. ... >format of any command. ... It is very difficult to run a command ... (comp.os.linux.misc) - Re: Select Email Adress using Check Box
... You can either use individual checkboxes for each email address, or a listbox that allows multiple selection. ... If the emails are each a row in a form, make that form a subform and put the command button on a parent form. ... and then export them into the "To:" adress bar in a new Microsoft Outlook ... (microsoft.public.access.formscoding) - Re: Multiple Recordset from a Stored Procedure
... This sample shows how to return multiple recordsets from database ... Also I note that ADO help suggests that we can roll our own multiple ... "If you open a Recordset object based on a compound command statement ... (comp.databases.ms-access) |
|