Re: [Sqlgrey-users] RELEASE: 1.5.9 + with throttling

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

Michel Bouissou wrote:

>Lionel, would you consider integrating this into the mainstream SQLgrey ? As 
>throttling is completely optional, "it doesn't hurt anyway", and somebody who 
>doesn't want the feature can just ignore it.
>  
>

# Throttling

"It doesn't hurt anyway" isn't enough. It must solve real world
problems. I'm aware that theoriticaly this is good to have less entries
in the connect table but as I said earlier the practical benefits aren't
clear to me yet.

Michel, could you give us a ratio between the results of:
grep "sqlgrey: grey: throttling: " | wc -l " (on a log spanning the last
max_connect_age period)
and
select count(*) from connect

on your configuration ? This would help measure the benefits of tarpitting.

If other users could fetch Michel's build and test it in the same manner
too that would be great.

# connect cleanup

I'm worrying about the LIKE. There are 2 problems with it:
- may hurt performance (I've no experience with it, I'm currently
guessing performance is OK),
- I'll have to check SQLite to see if it supports this.

Once I've a better understanding of the two points above, I'll make a
decision on the connect cleanup (should be shortly).

Lionel.