Hi Vladimir, i would thank you very much for your contribution. I've forwarded straight away your patch to bwstat's author - trusting your work will be useful to others.
Cheers, Paolo On Tue, May 08, 2007 at 10:32:29AM +0300, Vladimir Vitkov wrote: > Attached you can find the diff for bwstat. Used version was 0.25 > > On 07/05/07, Vladimir Vitkov <[EMAIL PROTECTED]> wrote: > >the current status is as follows > > * all stock indexes removed > > * added new indexes as follows: > > ** stamp_inserted, stamp_updated, ip_src, ip_dst, bytes, packets > > the indexes itself are on a single column and not combinations. > > * removed the leading "%' from the LIKE clauses > > * fixed 2 or 3 small bugs in bwstat (wrong column names) > > > >The net outcome from this is speed increase in the range of 10^1. > >Before this optimizations a single page with 64 ip's opened for 240+ > >secs, now in 10 (700K rows) and the machine this is running on is > >fuckin' low-end one :) > > -- > ?? ????????????????, > ???????????????? ???????????? > > http://www.netsecad.com > http://www.supportbg.com _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
