[samigo-team] [Building Sakai] FW: I am seeing on slow query related to samigo

[Aaron Zeckoski]

Let's give Karen and the Samigo team a chance to respond to this.
Here is the link for easy access:
https://jira.sakaiproject.org/browse/SAM-2192

-AZ


On Tue, Jul 30, 2013 at 2:08 PM, Kusnetz, Jeremy <JKusnetz at apus.edu> wrote:
> FYI, I've created JIRA SAM-2192 for tracking this.
>
> To me this is a pretty big blocker especially for schools with very large Samigo tables.  We are going to have to find a work around quickly as we just upgraded to the latest 2.9.x.  I'm worried that if we get enough of these queries at the same time it can take down MySQL.
>
> -----Original Message-----
> From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Sam Ottenhoff
> Sent: Tuesday, July 30, 2013 1:32 PM
> To: Kusnetz, Jeremy
> Cc: sakai-dev at collab.sakaiproject.org; Samigo Team
> Subject: Re: [Building Sakai] FW: I am seeing on slow query related to samigo
>
> So is changing the sub-select to a join a possibility?  If not, doing the sub-query first, getting the result in the app code, and then using the result in the second query should dramatically improve results.
> _______________________________________________
> 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"
> This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.
>
> _______________________________________________
> samigo-team mailing list
> samigo-team at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/samigo-team



-- 
Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile