Re: [Sqlgrey-users] slow performance

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

Beast wrote the following on 12.05.2005 10:42 :

>
> Hello,
>
> I run sqlgrey along with postfix on test environment (v1.5.5).
> Time between "rcpt to" command and "450: grey listed for 1 minute" is
> 17 seconds, is this normal?


No, this is far from what is expected (should be always under the second
and more in the 0.01 to 0.1 range). Especially with 1.5.x which is tuned
for large workloads.

>
> Database is mysql 4.1.7 and only contains 8 rows,


In which table ? SQLgrey uses a connect table for unknown clients and
then (if the clients reconnect) populates the from_awl and domain_awl
tables.

To rule out any problem with the database itself, how much time does it
take to do a "SELECT count(DISTINCT sender_domain) FROM connect;" for
example ?

Lionel.