Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Mon Nov 19, 2018 1:57 am
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Working with XMLDocument in a web application
PostPosted: Sat Feb 09, 2013 11:38 am 
Offline

Joined: Sat Feb 27, 2010 10:11 am
Posts: 18
Not sure where to put my question:-) My problem is as follows. I am building a web application in which I have to import a XML datadump from an ERP system. So an entire XML document has to be imported, after the import I parse the XML document and put the data in a sqlite database.

I succeeded in doing this by using XMLdocument, but this is taking a lot of time to upload and parse: only 15 MB takes about 30 minutes. My app freezes during parsing because XML Document is single threaded. I have read some posts that XML Reader is faster, but I cannot find any examples on how to work with the reader. The LR isn't helping me much either.. Is it maybe a better idea to leave XML Document and just import commaseparated textfiles?

Or, is XML Reader the way to go? In that case could anyone help me with a simple working example on how to work with the reader?

For your information, my app has to import appr. 2400 customers and 77000 invoiceheaders (no lines).

thanks in advance,
Jacco

_________________
Using RS2012R2.1
http://www.slok.com


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group