Question for all of those experiencing slow web admin GUI or DB queries ... but
first!
FGaudreault@inverse is a freaking genius ... no really!
With the current default setup in PF 3.5.1 I searched the DB for a MAC and it
took 181.760 seconds, before I had to kill the query because it was eating all
the CPU for my DB server (O.o)
After looking at the bug here http://www.packetfence.org/bugs/view.php?id=1534
I tried the new "improved" query ... aaaaaannndd got my result in .065 seconds
...
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?
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
------------------------------------------------------------------------------
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
