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??
Making an XML
Re: Making an XML
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
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
Oleg Yershov