Ying Zhang wrote:
On Tue, Jun 09, 2009 at 02:01:51PM +0200, John van Schie (DT) wrote:
Hi,
Today I tried to shred a XML document of 1.6 giga bytes using mclient and it took more than 3 hours (~150 kb/s) on a quite fast machine. I was a bit suprised. because for smaller documents shredding is quite fast. Are these numbers expected?
Hello John,
Have you maybe had a look at the system load during this time? Are there any other processes that were heavily using resources like disk, CPU?
Kind regards,
Jennie
Jennie, I have repeated the insertion twice while monitoring the machine for load. During both insertions, the load was constantly [1] 1.00, corresponding to 100% CPU load of MonetDB. Still, both times the document insertion took ~98 minutes (half of the previous reported time), but still high. Especially with regard to the insertion of an anonymized variant of the same document, that takes about 2 minutes to insert. Regards, John [1] Checked 1 minuted intervals