Re: [Sqlgrey-users] Suggestions for improvement

[David R. <dr...@gr...>]

Rene Joergensen wrote, On 12/16/2004 3:25 AM:
> - Cleaning from cron, calling sqlgrey with --db-clean (or seperate
>   perlscript (but that would mean more code to maintain)), this is in my
>   eyes a pretty flexible way, and non-blocking without rewriting SQLgrey
>   to use Net::Server::Prefork, and then just tell SQLgrey that cleaning
>   is done externally, and it doesn't have to worry about it. Default
>   should be one of the other ways, to avoid people who doesn't RTFM
>   complaining about large databases.

I think this one is a great idea.  I don't see the need for cleaning out 
the database maybe more than once every hour or so, and being able to 
move the cleanup process outside of the main sqlgrey process will reduce 
the latency hit of having the daemon itself do cleanup.  Not a big deal 
in your typical setup, but it will make a big difference in high volume 
setups.

-Dave