Michal, same question for you, which db did you use?

On Thu, Nov 1, 2012 at 12:09 PM, Michal Vanco <mvanco@redhat.com> wrote:
Hi,

I have some feedback on this topic as well.

I have tried 2 scenarios:
 1) initialization of portal with many pages (server startup time)
 2) jcr portlet (for writing some randon data in jcr) - portlet is accessed with concurrent users during perf test

ad 1)
3 portals with many pages at different structure are initialized (each portal has +- 780 nodes/pages - [size,height]: [5,4] , [27,2] , [780,1])
- EPP 5.2.2 started at 50m:51s:425ms
- JPP 6.0.0 ER02 started at 5154494ms = 85,9m
- JPP 6.0.0 ER02 with upgraded jcr core started at 5054052ms = 84,2m

Accessing these portals is much better at JPP 6 as I have already mentioned at previous email.

ad 2)
This is a refreshed scenario we have tested, textlogs from perf runs are attached - best results were with epp 5.2.2
For jpp 6, results were slightly better with upgraded jcr core
I'm also attaching jcr portlets which can be reviewed - write portlet is used, it adds some random data at jcr when portlet is accessed

Please keep in mind that it's a comparison of 2 major versions which are quite different, but I would expect these scenarios do not differ too much.

Best regards,
Michal

----- Original Message -----
> From: "Nick Scavelli" <nscavell@redhat.com>
> To: "Nicolas Filotto" <nicolas.filotto@exoplatform.com>
> Cc: "Michal Vanco" <mvanco@redhat.com>, "gatein-dev" <gatein-dev@lists.jboss.org>
> Sent: Tuesday, October 30, 2012 11:10:03 PM
> Subject: Re: [gatein-dev] Performance degradation between JCR 1.14 and 1.15?
>
> Ran some more tests as I saw 1.15 having better numbers for pages
> less then 500.
>
> Looks like the new jar is scaling better, and even outperforming 1.14
> except for 500 pages. Here are the results http://bit.ly/T2ghPK .
> The second tab shows the results for batching commits rather then
> waiting and committing 500 pages at once. 1.15 outperforms 1.14 in
> this scenario as well.
>
>
> On 10/30/2012 03:56 AM, Nicolas Filotto wrote:
>
>
> Do you have new results to provide? Especially on PGSQL?
>
>
> On Mon, Oct 29, 2012 at 9:26 PM, Nick Scavelli < nscavell@redhat.com
> > wrote:
>
>
>
> Some quick tests suggest there seems to be some improvement however
> the difference between 1.14 and 1.15 is still there. And it still
> seems to be the time that is spent in lucene updating the index
> (IndexWriter#addDocument). With the new jar it seems to indicate a
> little less time is being spent here, but no where close to the time
> spent in JCR1.14.
>
>
>
>
> On 10/26/2012 11:31 AM, Nicolas Filotto wrote:
>
>
> My mistake jcr.core is not enough you need core.database too, you can
> get the latest versions from here
> http://repository.exoplatform.org/content/groups/public/org/exoplatform/jcr/exo.jcr.component.core/1.15.0-GA-SNAPSHOT/exo.jcr.component.core-1.15.0-GA-20121026.152506-7.jar
> and here
> http://repository.exoplatform.org/content/groups/public/org/exoplatform/core/exo.core.component.database/2.5.0-GA-SNAPSHOT/exo.core.component.database-2.5.0-GA-20121024.105226-1.jar
>
>
> On Fri, Oct 26, 2012 at 7:37 AM, Michal Vanco < mvanco@redhat.com >
> wrote:
>
>
> Same for me with mysql when I was about to try initialization of
> manyPages in portal with upgraded jcr core. Log is here:
> http://pastebin.com/yqTXEbs5
>
> Michal
>
>
> ----- Original Message -----
> > From: "Matt Wringe" < mwringe@redhat.com >
>
>
> > To: "Nick Scavelli" < nscavell@redhat.com >
> > Cc: "gatein-dev" < gatein-dev@lists.jboss.org >
> > Sent: Thursday, October 25, 2012 10:12:20 PM
> > Subject: Re: [gatein-dev] Performance degradation between JCR 1.14
> > and 1.15?
> >
> > same with mysql
> >
> > On Thu 25 Oct 2012 04:05:52 PM EDT, Nick Scavelli wrote:
> > > Using both v1 and v2 I get errors in postgres. Full stacktrace
> > > here
> > > http://pastebin.com/BFAMW85M
> > >
> > > On 10/25/2012 08:43 AM, Nicolas Filotto wrote:
> > >> Here is the latest version
> > >> http://dl.dropbox.com/u/20836627/exo.jcr.component.core-1.15.0-CR2-SNAPSHOT-v2.jar
> > >>
> > >> On Wed, Oct 24, 2012 at 9:57 PM, Matt Wringe <
> > >> mwringe@redhat.com
> > >> <mailto: mwringe@redhat.com >> wrote:
> > >>
> > >> On 24/10/12 03:33 PM, Nicolas Filotto wrote:
> > >>> Could you please retry with this jar?
> > >>
> > >> I tested it quickly with the updated jar, and it seems to be
> > >> much
> > >> closer to the 1.14 results in my test when dealing with 500
> > >> pages. I will let Nick comment if it fixes the issues he was
> > >> seeing with import/export of sites.
> > >>
> > >>
> > >>>
> > >>> On Mon, Oct 22, 2012 at 2:51 PM, Nick Scavelli
> > >>> < nscavell@redhat.com <mailto: nscavell@redhat.com >> wrote:
> > >>>
> > >>>
> > >>> Here are results of some quick tests I ran on Friday
> > >>> using
> > >>> PostgreSQL. Note this is total time spent saving session
> > >>> after 500 pages, not time spent indexing.
> > >>>
> > >>> 1.15: 112.916s, 113.433s, 110.835s
> > >>>
> > >>> 1.14: 69.711s, 81.118s, 81.680s
> > >>>
> > >>> For 400 pages (only ran this test once)
> > >>> 1.15: 61.503s
> > >>> 1.14: 57.856s
> > >>>
> > >>> And the less pages the more closely 1.15 seems to perform
> > >>> close to 1.14. This is a very low sample size, and my
> > >>> tests
> > >>> might not best paint an accurate picture, but it does
> > >>> seem
> > >>> that 1.14 consistently out performs 1.15. So take it as
> > >>> you
> > >>> will. I'm also curious what performance is like if I
> > >>> would
> > >>> save the session after every page, instead of one large
> > >>> commit of 500 pages.
> > >>>
> > >>> - Nick
> > >>>
> > >>
> > >
>
>
> > _______________________________________________
> > gatein-dev mailing list
> > gatein-dev@lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/gatein-dev
> >
> _______________________________________________
> gatein-dev mailing list
> gatein-dev@lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/gatein-dev
>
>
>
> _______________________________________________
> gatein-dev mailing list gatein-dev@lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/gatein-dev
>
>
>