[Building Sakai] [samigo-team] FW: I am seeing on slow query related to samigo
Kusnetz, Jeremy
JKusnetz at APUS.EDU
Wed Jul 31 13:18:56 PDT 2013
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.
More information about the sakai-dev
mailing list