The most efficient ???

Results 1 to 3 of 3

Thread: The most efficient ???

  1. #1
    David Bergeron Guest

    Default The most efficient ???

    I was wondering something....<BR><BR>which of these two ways of adding,updating is the most efficient<BR><BR>- adding and updating using a Recordset<BR> or<BR>- adding and updating using the connection execute method<BR><BR>Tank you in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: The most efficient ???

    This is a suprisingly difficult question - there are many different ways of doing updates, which have different implications depending on how many updates you&#039re doing at once, what sort of database engine and connection you&#039re using etc. There is, however, a very good article benchmarking 6 different strategies on ASPToday at which you might want to have a look at.<BR><BR>Cheers<BR>Dunc

  3. #3
    Marty Weel Guest

    Default RE: The most efficient ???

    &nbsp;<BR>If you are using SQL Server..<BR><BR> I have had the most luck updating records with stored procedures and ado.<BR><BR>-Marty<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts