[Building Sakai] Samigo performance problems

[Steve Swinsburg]

Can you check your db logging for the slow query?

Cheers
Steve

Sent from my iPhone

On 10/09/2011, at 5:36, DAVID ROLDAN MARTINEZ <darolmar at upvnet.upv.es> wrote:

> No, that's the problem. Everything seems to be OK...however, if you load Samigo on that site it takes 16 s!!! to finish.
> 
> As Freddy Mercury would say: "It's a kind of magic". :D
> 
> Thanks!!!
> 
> David
> ________________________________________
> De: Sam Ottenhoff [ottenhoff at longsight.com]
> Enviado el: viernes, 09 de septiembre de 2011 17:18
> Para: DAVID ROLDAN MARTINEZ
> CC: sakai-dev at collab.sakaiproject.org
> Asunto: Re: [Building Sakai] Samigo performance problems
> 
> Hi David,
> 
> We have not seen this issue with 2.8.x.  Do you have a report on the offending slow query?
> 
> --Sam
> 
> On Fri, Sep 9, 2011 at 4:35 AM, DAVID ROLDAN MARTINEZ <darolmar at upvnet.upv.es<mailto:darolmar at upvnet.upv.es>> wrote:
> 
>        Hi all,
> 
>        We have just migrated from 2.6.0 to 2.8.0 and are experiencing performance problems with Samigo. Here are my tests:
> - I have checked if migration scripts have left some index invalid o unusable and everything is OK.
> - I have checked if I miss an index creating in migration scripts and everything is OK.
> - I have check if Oracle has statistics done...and everything is OK.
> 
>         The most important issue is that Samigo main page spends 16s!!!! to load 13 quizzes.
> 
>         Any idea?
> 
>          Thank you very much in advance.
> 
>          Cheers,
>                David
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"
> 
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"