Hi! I found this problem when I was trying to add many nodes using the API, it takes 6 or something seconds to use the function MakeNew. When I try adding a node in the UI it takes just as long time. Can it be something is messed up in my node structure in the db? Any advice on how to start digging into this? I will try using sql profiler for a start, but 6 seconds - thats an eternity for a couple of (?) db-execute's.
Ouch, this is kind of troublesome, I am to relase a site and I really like it to run fast and smooth like Umbraco should.
When I run SQL Profiler on this I find out that Umbraco fires of lots and lots of queries. First I thought that the many queries was due to some error in my node structure. Hovewer the queries runs very quick and I guess that just it's how Umbraco handles creation of new nodes, many quick calls to the db to get one node each, rather than a few queries that fetches a bunch of nodes each. The real time laps I found between SQL operations. Dunno what Umbraco' does then but there are two or three processes that takes more than two seconds each. Could it be writing umbraco.config cache file or something else involving disk operation? I will need to refreshen my memory on how to do some timing on .net-processes. Will have a look at that now... I'll be back. :-)
Bug or a messed up db?
Hi! I found this problem when I was trying to add many nodes using the API, it takes 6 or something seconds to use the function MakeNew. When I try adding a node in the UI it takes just as long time. Can it be something is messed up in my node structure in the db? Any advice on how to start digging into this? I will try using sql profiler for a start, but 6 seconds - thats an eternity for a couple of (?) db-execute's.
Ouch, this is kind of troublesome, I am to relase a site and I really like it to run fast and smooth like Umbraco should.
When I run SQL Profiler on this I find out that Umbraco fires of lots and lots of queries. First I thought that the many queries was due to some error in my node structure. Hovewer the queries runs very quick and I guess that just it's how Umbraco handles creation of new nodes, many quick calls to the db to get one node each, rather than a few queries that fetches a bunch of nodes each. The real time laps I found between SQL operations. Dunno what Umbraco' does then but there are two or three processes that takes more than two seconds each. Could it be writing umbraco.config cache file or something else involving disk operation? I will need to refreshen my memory on how to do some timing on .net-processes. Will have a look at that now... I'll be back. :-)
http://our.umbraco.org/forum/developers/api-questions/2537-Can-I-run-slow-admin-routines-in-the-background
The problems I had with slow publishing was that my smtp-settings was wrong, and notifications paused waiting for a non-existing server... our.umbraco.org/.../3459-Publish-(all)-stops-at-646-out-of-658-pages-
:-)
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.