Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Big XML
Message
De
10/12/2015 05:47:14
 
 
À
10/12/2015 04:59:34
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01628714
Message ID:
01628778
Vues:
44
The .FileSystemObject is the interface I meant "with script file API" in my second half of the message - perhaps a bit tooooo short ;-)


>>>>I have to import a discogs 21GB xml data file.
>>>>
>>>>Someone wrote a library that uses the API to read files larger than 2Gb.
>>>
>>>IAC use a streaming parser, not a DOM based one for such huge amounts. In your shoes I'd look at Java / SAX based solution or split the large file into bettter digestable slurps of a few hundred MB with script file API if the XML can be easily parted.
>>
>>I am writing in VFP,
>>using vfp2c32.fll to read the file.
>
>Hi Fabio,
>
>You can use the Windows FileSystem object, that do not have the VFP 2GB limitation:
>
>
>FSO = CreateObject("Scripting.FileSystemObject")
>SET MEMOWIDTH TO 180
>oTS = FSO.OpenTextFile('C:\DESA\foxbin2prg\pruebas varias\Fidel\zensayo2.sc2')
>DO WHILE NOT oTS.AtEndOfStream
>   cc = oTS.ReadLine()
>   * do something with cc
>ENDDO
>oTS.Close()
>
>
>You can read "lines" (ending with CR/LF) or you can read fixed-length text.
>The hard part is parsing the text. May be Thomas suggestion is a better approach for this.
>
>Best Regards.-
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform