RE: Resync or Requiry

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 03/04/04 

Date: Thu, 04 Mar 2004 02:09:28 GMT

Hi Michael,

Thank you for posting in the community!

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to know the performance
difference between Resync and Requery method. If there is any
misunderstanding, please feel free to let me know.

Based on MSDN document, Requery method updates the data in a Recordset
object by re-executing the query on which the object is based while Resync
mehod refreshes the data in the current Recordset object, or Fields
collection of a Record object, from the underlying database.

Unlike the Requery method, the Resync method does not re-execute the
Recordset object's underlying command. New records in the underlying
database will not be visible. It just looks in the data source for changes,
and then refresh the current Recordset. So generally, I think the Resync
method might be faster in performance.

For more information about Requery method and Resync method, please check
the following links for reference:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdmthadorequery.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdmthadoresync.asp

Does this answer your question? If anything is unclear, please feel free to
reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: Resync or Requiry
    ... The recordset returns a SINGLE row only ... Resync - The original SELECT has been taken apart and a SELECT is being ... returns a single row, a requery is better than a Resync. ... Requery method updates the data in a Recordset ...
    (microsoft.public.data.ado)
  • Using Resync with ADO and complex SQL Query statement using left outer joins
    ... I have a problem when I try to resync a recordset generated from a complex ... Set objCmd = CreateObject ... ANAGRAF ON DOCUMEN.codana=ANAGRAF.codana LEFT JOIN CATEG ON ...
    (microsoft.public.data.ado)
  • Union queries and batchoptimistic lock
    ... Whenewer I edit a record I use another dataset object ... query is refreshed). ... results because the resync method is called during the Post operation. ... Is there a way to append one recordset to another (and via this way ...
    (borland.public.delphi.database.ado)
  • [Update Resync] Wont Stop Resyncing!
    ... VB6 app; Recordsets updated using UpdateBatch. ... our app used the default "Update Resync" value ... to get back newly generated identity field ... Does anyone know why we can't STOP our recordset from resyncing? ...
    (microsoft.public.vb.database.ado)
  • Re: Refresh or Requery methode
    ... Requery method of ADO recordset re-execute query to update a recordset. ... Refresh is just a wrapper for the recordset's Requery method. ... ADODC has different set of properties and methods and names of some of them ...
    (microsoft.public.vb.database.ado)