I wanted to see how well umbraco would scale when adding lots of nodes and I noticed that the time it takes to add a document gets noticable progressively slower the more you add.
I just ran a test on the document.makenew() method by creating a 100 new textpages at a time and noting the amount of time it took to run and here are the results:
Run Times (in seconds)
9.87
9.69
20.49
32.52
37.95
55.35
69.45
87.19
117.62
129.23
And it keeps going up from there. If I go and delete all the items and empty the trash, runs times go back down to 9 seconds or so. I tried rebooting the server before emptying the trash, but that didnt seem to effect the times. It goes from less than a tenth of a second to insert a record to over 2 seconds, and the rate of increase seems to rise the more nodes I add.
I am running into the same issue but with 7000 records...frankly i can't get past about 2000 without a page timeout (which i can fix). Is there a faster way to do this same thing via Node or other slimmed down object. Is there a way to "bulk" import?
Can I create just one using MakeNew() and then use .Copy on it from there?
I have the same problem. I have not hd a look at the source but u guess its something the the sql that is used to save the content. May be raise it in http://issues.umbraco.org/dashboard
Could this be a concurrency issue?, If you have a thread queing up and queing up and queing up faster that the object that is locked can be worked on you are going to see these sort of figures?
Progressive slow down when inserting documents
I wanted to see how well umbraco would scale when adding lots of nodes and I noticed that the time it takes to add a document gets noticable progressively slower the more you add.
I just ran a test on the document.makenew() method by creating a 100 new textpages at a time and noting the amount of time it took to run and here are the results:
Run Times (in seconds)
I am running into the same issue but with 7000 records...frankly i can't get past about 2000 without a page timeout (which i can fix). Is there a faster way to do this same thing via Node or other slimmed down object. Is there a way to "bulk" import?
Can I create just one using MakeNew() and then use .Copy on it from there?
I have the same problem. I have not hd a look at the source but u guess its something the the sql that is used to save the content. May be raise it in http://issues.umbraco.org/dashboard
Charlie :)
Could this be a concurrency issue?, If you have a thread queing up and queing up and queing up faster that the object that is locked can be worked on you are going to see these sort of figures?
Charlie :)
is working on a reply...