alLANBilling and alSUMBilling database optimization

Please delete old indexes before!

I recomend to add this indexes to speedup processing:

KEY `unix_secs` (`unix_secs`),
KEY `dstusecs` (`dstaddr`,`unix_secs`),
KEY `srcusecs` (`srcaddr`,`unix_secs`),
KEY `output` (`output`,`unix_secs`)

KEY `unix_secs` (`unix_secs`),

KEY `dstusecs` (`dstaddr`,`unix_secs`),

KEY `srcusecs` (`srcaddr`,`unix_secs`),

KEY `output` (`output`,`unix_secs`)

This entry was posted in alLANBilling, alSUMBilling. Bookmark the permalink. Both comments and trackbacks are currently closed.