Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLTOCURSOR too slow
Message
From
06/12/2001 12:12:27
 
 
To
06/12/2001 10:46:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00589312
Message ID:
00590620
Views:
29
>>Where are these objects residing? On a Client form (ASP PAGE) and a 2nd tier on an internet server?
>>
>>The volume of data that you are looking at was not intended for XML in todays environment. Sorry but 5000 transactions as wide as you were interested in will blaot. Maybe ADO instead? It has to be faster.
>>
>>__Stephen
>
>
>I'm pretty much in the beginning stage of learning xml, so bear with me.
>
>Both FedEx and UPS have xml tracking. They say you can search for tracking #'s up to 365 days old. That is millions or 100's of millions of records. Doing an xml search takes a couple seconds.
>
>Am I missing something?

You bet - the XML transport is only the result sets; the queries are serviced on large data server engines behind the data tier; you never get to see the hundreds of millions of transaction records in your app.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform