Node creation taking up to 30 seconds!

[jppereyra]

Hi all,

We are having a weird issue. Node creation through the Alfresco Repository API is taking up to 30 seconds in some cases, and the same goes for moving a node among spaces. This is an issue I haven't seen before, and these are the things I've already checked:

- Disk access is not an issue, hdparm -t reports normal results.
- DB access, mysql innodb status doesn't report anything out of the usual.
- Other I/O issues, the time consumed while the node creation takes place seems to be dedicated to hibernate-mysql queries, lots of them, one every couple of milliseconds, for more than 15-20 seconds.
- Lucene presents no issues acquiring locks or searching the indexes

I don't have the code right now but I can post it tomorrow. At first, I thought that the issue was the amount of nodes in the same space (>5000) but with an empty space the same happens. The process is as follows, when a new file (an xml) is uploaded to a given space (inbox), the xml is parsed and an Alfresco node is created and then moved elsewhere. Any ideas?

Thanks!

[zomurn]

What kind of data do you upload ?
Are you indexing a lot of stuff on each document ?
> 5000 into ONE SAME space is not recommended I think due to "name collision check" which is time consuming. I'am currently coding auto creation of "bucket" space that will contains 1000 documents…no more.
Finally, do you include preprocessing time on the uploaded document in the 20s (parsing xml) ? (It may be long depending of your code)
Do you do some repository queries before moving the node ? Which one ?