Re: Timing Rescordset

hgeron wrote:
I searched many Access help web sites looking for examples
of reading an xml file and storing the data into tables.
I found very little info for Access. Most I found would not
work in Access modules. Most required some language
that is not possible for me to use. What every I develop
must be already installed in our CCE computers (a USDA
standard configuration)

I will lookup "parameter query", but I think you mean a
query that will allow me to pass the table name and data
to store the XML data.

No, you cannot pass the table name: only the data.

But from what I have learned in the
last month working with XML, it's the parsing of XML that's
the time consuming activity, not storing the data in a recordset.


Nobody ever said that xml was fast. :-)

My current method reads 1000 line nodes then stores 1000 node
into a record set. Reading 1000 nodes of XLM takes many 3 or 4
minutes but storing into the recordset takes only a second.
It's the parsing of XML I need to improve.
I don't see how a parameter query would help.

Am I missing you point?

Yes.
I was not suggesting parameter queries in the interests of performance. I
was addressing your specific question about cancelling the update. Using a
saved parameter query would allow you to avoid the problem you are having
with cancelling the update (just don't run the query if the node is the
wrong type).

Anyways, you seem to have missed my comment about checking the node type
BEFORE adding the data to the recordset. It seems to me that would also be a
solution to your problem. Check the node type. If it's a text node, don't
add a new record to the recordset: move to the next node.

--
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: How to Programmatically Export as XML & SXL
    ... Unfortunately, I've had precious little to do with XML in Access, so I'm ... you use the ADO Recordset object's Save ... >>Dim rs As ADODB.Recordset ... >>Dim strADTGFile As String ...
    (microsoft.public.access.externaldata)
  • Re: MDAC Converting Dataset to XML
    ... I hadn't realised there was a later version of MDAC than the one we had ... recordset is fine, the code that does this is a mirror of the conversion to ... XML and for completeness I include a copy (albeit ... Can you reproduce the symptom by saving the first piece of xml to a file, ...
    (microsoft.public.data.ado)
  • Re: Database + dll
    ... You can include an XML or ADTG persisted Recordset with the ... XML can be compiled into a DLL as a resource, ... copied to a stream first anyway (not that the recordset would alter the ... It's a simple matter of creating a custom resource type from an XML file at ...
    (microsoft.public.vb.database.ado)
  • Re: Timing Rescordset
    ... The problem was that it took hours to read a big xml file. ... then use a recordset to store them. ... avoid levels of recursion that lack substantial advantage. ... parameter query will not accept the node name as a parameter as a table ...
    (microsoft.public.data.ado)
  • Re: adodb.recordset.save and back
    ... persisted XML file back into recordset, ... Dim Rs as New ADODB.Recordset ... and when you reconnect it to the database you get the error ...
    (microsoft.public.data.ado)
Loading