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

[Kusnetz, Jeremy]

FYI, we submitted a patch in that JIRA which splits up the query and joins them together in the app.  It seems to be working well in our test instances.

Jeremy Kusnetz | Sr. Systems Engineer

American Public University System 
American Military University  |  American Public University
661 S George Street, Charles Town, WV 25414 
T 304-885-5333 | M 703-967-5212 |  jkusnetz at apus.edu| www.apus.edu


-----Original Message-----
From: azeckoski at gmail.com [mailto:azeckoski at gmail.com] On Behalf Of Aaron Zeckoski
Sent: Tuesday, July 30, 2013 2:15 PM
To: Kusnetz, Jeremy; Karen Tsao
Cc: Sam Ottenhoff; sakai-dev at collab.sakaiproject.org; Samigo Team
Subject: Re: [samigo-team] [Building Sakai] FW: I am seeing on slow query related to samigo

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
This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.