Re: [Sqlgrey-users] Logging

[Lionel B. <lio...@bo...>]

Rene Joergensen wrote the following on 01/13/05 10:48 :

>It always nice to help enhancing a good piece of software/idea.
>
>Speaking of performance reports, do you need more info to be able to
>decide on which indices to use?
>  
>

In 1.5.x there will be an index on connect.ip_addr. This is the most 
obvious one and greatly improved the load on a mysql database (see 
db_performance_reports).

There could be some benefit for indices on the timestamp in the 3 
tables, but surprisingly it seems the cleanup process (which is the 
obvious target for timestamp related optimisations) didn't benefit much 
from it when tested. As adding indices slow the database writes I'm not 
considering adding timestamp ones yet (until someone brings test results 
where the db_cleanup is reduced from say 5s to 0.5s when adding one of 
them for example).

1.5.x won't start until February as I'll be skiing from Saturday until 
then and 1.4.x still has some TODOs.

Lionel.