Page 1 of 1

Making an XML

Posted: Wed Jan 06, 2021 10:43 am
by noithatgooccho
dear readers,

I've a question. I'll have to make a xml form som fields off a database. For that I've used the [DEMO] Create XML library.

My only problem is that this task task a very long time to run?

When I limit the results to about 10 lines, no problem. But when I don't limit the results it are about 23,000 lines. I run the task but after 6 hours the XML isn't still ready??

Do I miss something??

Re: Making an XML

Posted: Wed Jan 06, 2021 2:15 pm
by Oleg
The larger the file, the longer it takes to add a node.
I tried to create XML from database

when I select 100 records the task works 3 seconds
when I select 500 records the task works 54 seconds (not 15 seconds)
when I select 1000 records the task works 205 seconds (not 108 seconds)

In the beginning the task processes 32 records per second
at 500-th record the speed is 5 records per second
at 1000-th record the speed is 2-3 records per second

So, I'm afraid that you will wait 23000 records very very long time...
Maybe it's better to create many small XML files: each file must contain 300-500 records only