2011/5/19 Gerhard Lausser <gerhard.laus...@consol.de>
> Hi,
>
> > size. For example, I can display the unhandled hosts problems
> > page in less than 5 seconds but unhandled services problems
> > page can take up to 15 seconds to be sent to my browser.
> in this case, there's sorting of the host or the service list required,
> which might be the reason, why the livestatus query takes so long.
> Can you please edit file livestatus.py and search for the method "def
> get_services_livedata" and
> change line
> return self.get_hosts_or_services_livedata(cs, lambda k: (k.host_name,
> k.service_description))
> to
> return self.get_hosts_or_services_livedata(cs, lambda k: k.host_name +
> k.service_description)
>
> Gerhard
>
Thanks for your help
I'll try your patch this afternoon and tell you what happens
And for the livestatus.db, I have tried your command to count the entries
and it gave me. A cleaning up in cron might be a good idea, like you said
:-p
sqlite3 /usr/local/shinken/var/livestatus.db "select count(*) from logs
where time < strftime('%s', 'now') - 3600*24*7"
483973
Denis
>
> __________ Hinweis von ESET NOD32 Antivirus, Signaturdatenbank-Version 6133
> (20110518) __________
>
> E-Mail wurde gepruft mit ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
> ------------------------------------------------------------------------------
> What Every C/C++ and Fortran developer Should Know!
> Read this article and learn how Intel has extended the reach of its
> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> developers boost performance applications - including clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Shinken-devel mailing list
> Shinken-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/shinken-devel
>
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Shinken-devel mailing list
Shinken-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/shinken-devel
