Re: blog.jsp jahia4.1.1 abysmal performances

Ok, good point, load is intersting, never seen it like this...  between 0,2%
to max 2% on Jahia, load on mysql climbs gently to 44% when the page is
served, and get down slowly after.

ex with page served at 90 sec.:
seconds:         000  001  002  030  060  090  120  180
load jahia %:    0.4  002  0.4  0.4  0.4  0.8  0.4  0.4
load mysql %:    0.1  002  004  022  038  044  022  0.1

Useless, but funny...

Anyway, definitely an issue with the DB. I don't have the rights to do it
myself, but will ask that the indexes be applied again, it shouldn't hurt.

I've already made a custom container list with the functionalities nedded
for my case. I'll use that for now.

Best regards,
Nicolas

2006/7/12, Michel Romy <[email protected]>:
>
>  Hi,
>
> we mostly do our tests on linux and windows, but I don't see why it would
> be different with you environnement.  We are using the blog template on the
> jahia.net website (
> http://www.jahia.net/jahia/Jahia/cache/bypass/pid/702?entryId=3050 ) and
> process time is between 500ms and 1 second.
>
> Could you check when you access the page if the load is on Jahia or on the
> DB ?
>
> Regarding indexing of the DB, if you have already applied these indexes
> http://www.jahia.net/jahia/page589.html#6  normally no other indexes
> should be needed.
>
> best regards,
> Michel
>
>
>
>
> I forgot to add that I'm using mysql-standard-5.0.16-solaris10-sparc-64biton
> jahia4.1.1
>
> I hope it's not a factor in this case, but you never know..
>
> 2006/7/11, Nicolas Hagner < [email protected] >:
>  Hello Stéphane,
>
> DB should be correctly indexed (how can I check? should I force a
> reindexing?). No performance problem with any other templates (news, faq,
> etc...), just blog.jsp
>
> I don't have access to another server for a fresh installation at work.
> And I decommissioned my sun workstations at home, so won't be able to
> replicate...
>
> There is no slowdown of jahia while it processes this page. (meaning all
> pages are accessed normally while jahia is processing this page).
>
> It is not a page content problem as the page is freshly created, with just
> two very small test entries in it.
>
> Nicolas
>
> 2006/7/11, Stéphane Croisier <[email protected]>:
>
> Did you correctly indexed your DB? Else if you install a fresh version of
> Jahia on another server, do you have the same issue? Or is it just on your
> existing installation?
>
> Stéphane
>
>
> At 09:55 11.07.2006, you wrote:
>
> Hello,
>
> I wish to add pages with very close functionalities to the blog.jsptemplate in on of my intranets, unfortunately while using
> corporate_portal_templates performances are catastrophic!
>
> From the logs:
>
>
> 42088072 [http-8080-Processor5]  INFO - Processed
> [/jahia/Jahia/site/trenz/op/edit/pid/320] user=[NCH] ip=[ 155.66.250.149]
> in [102910ms]
> 42195158 [http-8080-Processor4]  INFO - Processed
> [/jahia/Jahia/site/trenz/op/preview/pid/320] user=[NCH] ip=[
> 155.66.250.149] in [89114ms]
> 42214975 [http-8080-Processor4]  INFO - Processed
> [/jahia/Jahia/site/trenz/op/preview/pid/221] user=[NCH] ip=[ 155.66.250.149
> ] in [434ms]
> 42306908 [http-8080-Processor4]  INFO - Processed
> [/jahia/Jahia/site/trenz/op/preview/pid/320] user=[NCH] ip=[155.66.250.149]
> in [90167ms]
> 42369430 [http-8080-Processor3]  INFO - Processed
> [/jahia/Jahia/site/trenz/op/preview/pid/16] user=[NCH] ip=[ 155.66.250.149]
> in [125ms]
> 42371743 [http-8080-Processor3]  INFO - Processed
> [/jahia/Jahia/site/trenz/pid/18] user=[NCH] ip=[ 155.66.250.149] in
> [391ms]
> 42374509 [http-8080-Processor4]  INFO - Processed
> [/jahia/Jahia/site/trenz/pid/221] user=[NCH] ip=[155.66.250.149 ] in
> [359ms]
> 42378998 [http-8080-Processor4]  INFO - Processed
> [/jahia/Jahia/site/trenz/op/preview/pid/221] user=[NCH] ip=[
> 155.66.250.149] in [398ms]
> 42470074 [http-8080-Processor4]  INFO - Processed
> [/jahia/Jahia/site/trenz/op/preview/pid/320] user=[NCH] ip=[ 155.66.250.149
> ] in [89306ms]
>
> 'Other' pages (pid 16, 18, 221) are processed between 125ms and 400ms.
>
> But the page using blog.jsp as template (pid 320) can't seem to be below
> 80000ms ! 200 slower!
>
> Do someone has a clue or a way to further debug this, because I definitely
> can't use it that way.
>
> Best regards,
> Nicolas
>
> --
> Nicolas Hagner
> Firmenich S.A.
>
>
>
>
>
> --
> Nicolas Hagner
> Firmenich S.A.
>
>
>
>
> --
> Nicolas Hagner
> Firmenich S.A.
>
>


-- 
Nicolas Hagner
Firmenich S.A.