Why is displaying documents in Sections so much slower than in Workspaces?

[zerubbabel_]

We have about 5000 documents (.odt files) that are published in Sections, and about a thousand more being worked on in the Workspaces. To display a particular document's properties from its Workspace folder takes about 6 seconds. To display the properties of the same document from where it is published in a Section takes more than 20 seconds. Why the dramatic difference? How can this operation be speeded up?

[bruce_Grant]

Apart from this issue, six seconds to see document properties seems very slow especially with only 5000 documents. Difficult to answer without much more detail...

[zerubbabel_]

Platform

[Benjamin_Jalon1]

We strongly suspect that your server swap as you just have 1.5Go. (by default our tomcat instance is started with 1024Mo allowed). So I recommend you to buy some memory sticks or tune your server

[zerubbabel_]

Result of "SELECT * FROM Document" -- 668 pages at 20 per page

[Benjamin_Jalon1 · Accepted solution]

So I hope with your memory upgrade you will have better response time, but I can explain you why you have a response time difference for your published document and the original one.

In fact when you publish your document you're creating what we call "Proxy". This is a pointer to the original document.

Into the database in fact we create a document that reference the original document. So to find any information of the original document, we need to execute a database request with join that is less efficient to get directly the original document. Normally this join is quite efficient when the Database don't swap.

As your server is light for the memory the response time gap is large. But if you do that in well dimensioned server the difference will be sensitively shorter.

I will finish on this documentation. There is a section about Tuning your PostgreSQL Database to have the best response times.

[Benjamin_Jalon1]

Ok, so your server must swap.