Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Practical limits to XMLTOCURSOR()?
Message
From
25/04/2007 16:48:02
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01219904
Message ID:
01219928
Views:
10
Hi Harold,

We bring in up to 4 megs of XML for UI controls (e.g. grids) and up to 16 megs for reports. Actually, 16 megs is the limit for a memory variable.

Trick is:

[1] Set PreserveWhiteSpace = .T. when executing the XMLAdapter LoadXML and ToXML methods.
[2] Set FormattedOutput = .F. when executing the XMLAdapter ToXML method.
[3] Make sure the client box has at least one gig of memory.

Also, you may want memo fields wrapped in CDATA to circumvent parsing errors for invalid XML characters (e.g. &,<,> etc)

>Hello
>
>I am using XMLTOCURSOR to import records...The command works fine up to about 30k records and then hangs the machine after that... Are there some practical upper limits to the number of records that can be imported via XMLTOCURSOR()???
>
>Thanks!
>Harold
- Jeff
Previous
Reply
Map
View

Click here to load this message in the networking platform