There are 4 columns. In two there are 50k rows, and other two are empty.
Yes, CPU usage is 100% but usage of memory doesn't increases. In this case there are 100 Mb available memory.
I have tried also with 5 MB (10.000 rows) document but it's same as with 16 MB.
I am suprised that this totally kills VFP, I think that isn't to much for processing XML.
Any solution?
>Boban,
>
>I imagine that it is just taking the XMLDOM a long time to construct that large a document in memory. You say it's 50k rows how many columns are there?
>
>Have you watched on the task manager to monitor CPU and memory use? I would imagine that the CPU pegs at 100% and memory use steadily increases. XML is not a linear process either. Have you tried a 1, 2, 4, 8 and finally 16mb document to see how well it works?
>
>>I have tried to do XMLTOCURSOR() from .XML file which size is 16 MB and
>>result is that VFP not responding.
>>In .XML file there are 50.000 records.
>>
>>Is it to much 16 MB .XML file for XMLCURSOR() function to handle it?
>>
>>Can someone comment on this?
>>
>>I have tried that on machine Pentium 3, 256 DDR RAM.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement