Nuxeo 5.2 VCS extremely slow

[jiveforums-ecm]

Hello All,

I'm wondering if I have missed something here.  We are running Nuxeo 5.2 DM (using both H2 and Postgres)  We have roughly 9,000 documents ( select count(*) from hierarchy ), unfortunately for some strange reason it takes a very long time (order of a 1/2 a minute)  to navigate from one branch of a tree to another.

Is there something we need to do to tune the database?

Thanks,

Carlos
--
Posted by "ceperez" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8183>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

I ran repostats and got this:

Total number of documents:8697
   Number of PersonnelSite docs: 111
   Number of PostalAddressSite docs: 111
   Number of InBasic docs: 937
   Number of InAddress docs: 929
   Number of PersonSite docs: 111
   Number of PlaceSite docs: 111
   Number of CasCivilian docs: 1
   Number of VehicleSite docs: 111
   Number of Department docs: 111
   Number of TelecomNumberSite docs: 111
   Number of Root docs: 1
   Number of SectionRoot docs: 2
   Number of InOwnerPerson docs: 585
   Number of InApparatus docs: 932
   Number of TemplateRoot docs: 2
   Number of WorkspaceRoot docs: 2
   Number of IncidentKey docs: 942
   Number of InAuthority docs: 929
   Number of Domain docs: 2
   Number of FireIncident docs: 942
   Number of InMutualAid docs: 929
   Number of InFire docs: 34
   Number of Folder docs: 242
   Number of EquipInvolved docs: 35
   Number of Workspace docs: 111
   Number of ElectronicAddressSite docs: 111
   Number of MobileProp docs: 34
   Number of FireIncidentSite docs: 107
   Number of DepartmentSite docs: 111
Folders
   Maximum depth: 12 in /..
Repository performance during stats was 278.1616 doc/s

But the web interface is still really slow it takes 25 seconds just to navigate down one level of the tree.
--
Posted by "ceperez" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8184>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[Mihai Durbaca]

Try putting in your query the condition ecm:isProxy=0, like:

SELECT * FROM Document WHERE ecm:isProxy=0

In my case it worked.

HTH

În data de Vineri 28 August 2009 02:59:57 jiveforums-ecm@... a scris:

> I ran repostats and got this:
>
> Total number of documents:8697
>    Number of PersonnelSite docs: 111
>    Number of PostalAddressSite docs: 111
>    Number of InBasic docs: 937
>    Number of InAddress docs: 929
>    Number of PersonSite docs: 111
>    Number of PlaceSite docs: 111
>    Number of CasCivilian docs: 1
>    Number of VehicleSite docs: 111
>    Number of Department docs: 111
>    Number of TelecomNumberSite docs: 111
>    Number of Root docs: 1
>    Number of SectionRoot docs: 2
>    Number of InOwnerPerson docs: 585
>    Number of InApparatus docs: 932
>    Number of TemplateRoot docs: 2
>    Number of WorkspaceRoot docs: 2
>    Number of IncidentKey docs: 942
>    Number of InAuthority docs: 929
>    Number of Domain docs: 2
>    Number of FireIncident docs: 942
>    Number of InMutualAid docs: 929
>    Number of InFire docs: 34
>    Number of Folder docs: 242
>    Number of EquipInvolved docs: 35
>    Number of Workspace docs: 111
>    Number of ElectronicAddressSite docs: 111
>    Number of MobileProp docs: 34
>    Number of FireIncidentSite docs: 107
>    Number of DepartmentSite docs: 111
> Folders
>    Maximum depth: 12 in /..
> Repository performance during stats was 278.1616 doc/s
>
> But the web interface is still really slow it takes 25 seconds just to
> navigate down one level of the tree. --
> Posted by "ceperez" at Nuxeo Discussions <http://nuxeo.org/discussions>
> View the complete thread:
> <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8184>
> _______________________________________________
> ECM mailing list
> ECM@...
> http://lists.nuxeo.com/mailman/listinfo/ecm
> To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

--
 Mihai-Alexandru DURBACA
 Software Engineer
 Business & Decision
 E-mail: mihai.durbaca@...
 Phone: [phone]
 Yahoo! IM: mdurbaca@...
 MSN IM: mdurbaca@...
 Skype: mitzud
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

For additional comparisons:

(1) I've tried this on the August 19 build of 5.2.1.  Although this build is more responsive, I still see the same slowdown as I add more documents.

(2) I've tried this with a JCR backend for the August 19 build of 5.2.1 and I did NOT see it slow down significantly.

There is definitely something about VCS that causes a slow down.  I however can't figure out why or what is causing it.
--
Posted by "ceperez" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8193>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

Hi,

Vcs has been tested with milions of documents and performance remain good even in the default jsf app: about 30 req/s and 0,5 s average response time.

But when using vcs, you have to keep in mind that:
 - you must use a real database (not h2)
 - you must tune the db server
For exemple, pgsql default config does not work:  you must apply std tuning as explained on the wiki.

In addition we have already done perf improvements in the trunk and plan to optimize security check before next release.

Anyway, please check your db server config and tell us how it goes.

Tiry
--
Posted by "tdelprat" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8218>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

OK.

Apply the changes as described in:  http://www.nuxeo.org/xwiki/bin/view/FAQ/PostgreSQLSettings/

So far looks better in Nuxeo 5.2.0.

Thanks,

Carlos
--
Posted by "ceperez" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8219>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

Sigh... scales better... unfortunately Search (among other things) is broken.
--
Posted by "ceperez" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8235>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

Hi, "is broken" is insufficient information for us to help you, sorry.
--
Posted by "fguillaume" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8244>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

Hello,

I'm not describing a bug that is not easy to replicate.

You can replicate it yourself, by cutting and pasting documents.   I've done it on my laptop, I've done it on a quad core server, I've done it on Nuxeo's own cloud.   It's the same problem, searches simply do not return.

Acknowledgment of a problem is typically a step in fixing it.

Regards,

Carlos
--
Posted by "ceperez" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8269>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

The upcoming version of Nuxeo fixes a number of performance issues, notably related to search, the navigation tree, speed of security checks, etc.
--
Posted by "fguillaume" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8275>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

Thanks!!!  We'll be testing it immediately.
--
Posted by "ceperez" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8286>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

[jiveforums-ecm]

Hi, any notice about this issue?

Thanks.
--
Posted by "jisi" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2820#8784>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm