Re: Timing Rescordset

hgeron wrote:
Bob,

continued

The procedure was so time consuming, I decided to catch the data to an
array, and then record back to the table every 1000 lines of XML.
Since it was an array
I could deincrement the counter, and save the node.txt in the array.

This worked out to be much faster, and avoided the cancel update, and
the move last. But this still bothers me...
(1) Why does it think that node_text is a new node?

Because it is. That's more af an XML question rather than an ADO question
....
You would be better off testing the node type BEFORE adding data to the
recordset, wouldn't you?


(2) Why does the cancel update, then move last, seem to not give me
the
last record immediately, but if I put a wait, or several move last
commands, then I can be sure (usually) of getting the actual last
record.

No clue, beyond the possibility that you are running into the Jet
delayed-write behavior.

I wouldn't be using a recordset for this: I would be passing parameters to a
saved parameter query. Reply if you wish to consider that approach and I'll
give you some details.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Urgent: getting recordcount after running Stored Procedure
    ... select street_name, city, state ... ... To loop through the array, ... for iColumn = 0 to ubound ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: How to execute this parameter query?
    ... My guess for now is that this is just a bug in the Firebird driver. ... Array function returns an uninitialized array with an upper bound of ... Provider Friendly Name Microsoft OLE DB Provider for ODBC Drivers ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: How to execute this parameter query?
    ... like an ordinary function than a statement. ... and this assigns the value to the second element in the array. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: array curiousity with split
    ... > An array created by the split function seems to behave differently. ... > dim mainArray ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Timing Rescordset
    ... The XML may contain many records, ... an array, and then record back to the table every 1000 lines of XML. ... parameters to a saved parameter query. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
Loading