Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLTOCURSOR too slow
Message
From
04/12/2001 11:12:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
XMLTOCURSOR too slow
Miscellaneous
Thread ID:
00589312
Message ID:
00589312
Views:
92
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
Next
Reply
Map
View

Click here to load this message in the networking platform