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: 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: 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)
  • Re: Printing to file with more than one page
    ... I have 27 figures and I need to print them to .pdf file, ... I know, how to print on one page with command "print", but I can't find, how to print on more pages. ... You could use the subplot command to put multiple plots on one figure. ... storing handle of each in the figs ...
    (comp.soft-sys.matlab)
  • Multiple Combo Boxes as Criteria for Continuous Form
    ... combo boxes and click command button that will then list some information ... The code for the command button is: ... Private Sub Btn_OpenUpdateList_Click ... form multiple times. ...
    (microsoft.public.access.formscoding)