Re: ADO Performance question

>>>
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)
Quantcast