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-64bit on 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.jsp template 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.

Reply via email to