Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLTOCURSOR too slow
Message
From
07/12/2001 23:40:56
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00589312
Message ID:
00591603
Views:
22
Hi Michelle

Are you using VFP6 or VFP7?

The inplementation in VFP7 was quoted as being dranatically faster in VFP7 at one of the Devcons.

Geoff

>I need to pass data from a cursor from one object to another, so I decided to check out XML. It seemed like a perfect fit until I ran it and saw how slow it is.
>
>This line:
>lnNumRecs = XMLTOCURSOR(tcDataString, "tc_addrs")
>
>takes 98 seconds on my Celeron 600 with about 4800 records. Each record has 12 fields. This is way too slow for my needs. Since I'm new to XML, I thought maybe I was just missing a way to optimize it. Is it normal to take this long? Creating the XML from the cursor only takes half a second. What am I missing?
>
>Thanks,
>
>Michelle
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform