Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Practical limits to XMLTOCURSOR()?
Message
De
25/04/2007 16:48:02
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01219904
Message ID:
01219928
Vues:
11
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform