I could not find any instructions in the bug report to apply the patch, could you let me know where I can find some?
Also, I would be happy to share a HEAVILY sanitized copy of our database with you guys if you would like to use it for testing these kinds of things. We are strictly RADIUS-MAC auth so there shouldn't be too much info that would need to be redacted. Jake Sallee Godfather of Bandwidth System Engineer University of Mary Hardin-Baylor 900 College St. Belton TX. 76513 Fone: 254-295-4658 Phax: 254-295-4221 HTTP://WWW.UMHB.EDU -----Original Message----- From: Olivier Bilodeau [mailto:[email protected]] Sent: Thursday, September 20, 2012 10:50 AM To: [email protected] Subject: Re: [PacketFence-users] Concerning slow Web Admin GIU and/or DB queries. Hi Jake, On 09/19/2012 10:48 PM, Sallee, Stephen (Jake) wrote: ... > > So, has anyone put this query into production? According to my > calculations this is at least a 99.964% improvement ... or for the > number nerds amongst us ... approx. 2,796.308 x faster ... is there any > reason I should NOT use this patch? No, absolutely not. It was simply a badly done query that was fixed. It's hard to get these things right the first time when we don't have as much data as you guys in our lab. And we don't have a DBA handy. We have been learning how to fight database bottlenecks lately and you can help also if you want. Here are incredible tools for MySQL performance analysis: http://www.percona.com/doc/percona-toolkit Cheers! -- Olivier Bilodeau [email protected] :: +1.514.447.4918 *115 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://ad.doubleclick.net/clk;258768047;13503038;j? http://info.appdynamics.com/FreeJavaPerformanceDownload.html _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://ad.doubleclick.net/clk;258768047;13503038;j? http://info.appdynamics.com/FreeJavaPerformanceDownload.html _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
