Hi Peter, On Mon, Jun 05, 2006 at 05:46:43PM +0300, Peter Nixon wrote:
> Yep. I am optimizing the indexes as we speak. I now have the following > indexes > on both tables, and it has made a significant difference to system load. > > [ ... ] > > I have also deleted all unnecessary fields from the schemas (Mac Address etc). I would also add: if possible, try to avoid UPDATEs at all by turning on the sql_dont_try_update key (for conditions and further details, please give a look to CONFIG-KEYS). Cheers, Paolo PS: sql_cache_entries default value is 32771. Documentation updated! _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
