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
