Re: Resync or Requiry

From: Michael Tissington (michael_at_nospam.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 10:18:18 -0800

Keven,

Thanks but this really did not answer my question.

The recordset returns a SINGLE row only .... so there will not be any new
rows, but the data may have changed for some of the columns.

When I look at profiler I see the following

1) Requery - A single trip to the server with the original SELECT

2) Resync - The original SELECT has been taken apart and a SELECT is being
issued against for each of the tables in the original SELECT (so multiple
trips to the server)

I guess I'm answering my own question here, that for a recordset that
returns a single row, a requery is better than a Resync. 

-- 
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com
"Kevin Yu [MSFT]" <v-kevy@online.microsoft.com> wrote in message
news:7pc1E3YAEHA.2304@cpmsftngxa06.phx.gbl...
> 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

  • 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)
  • RE: Resync or Requiry
    ... difference between Resync and Requery method. ... Requery method updates the data in a Recordset ... mehod refreshes the data in the current Recordset object, ...
    (microsoft.public.data.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: Set a SQL Result as Variable
    ... You need to open a recordset, and refer to a specific field in a specific ... If your query only returns a single row, ...
    (microsoft.public.access.modulesdaovba)