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?

Benjamin_Jalon1

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.