Re: [Sqlgrey-users] slow performance

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

Beast wrote the following on 13.05.2005 10:35 :

> Lionel Bouton wrote:
>
>>
>> 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.
>>
>
> In connect table, other less than 6 entries.
>
>> 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 ?
>>
> mysql> SELECT count(DISTINCT sender_domain) FROM connect;
> +-------------------------------+
> | count(DISTINCT sender_domain) |
> +-------------------------------+
> |                             6 |
> +-------------------------------+
> 1 row in set (0.05 sec)
>
>

This is normal. Could you post the output of 'postconf -n'? As SQLgrey's
only time consuming operations are SQL queries, I suspect something
other in your Postfix configuration is causing this. If you take SQLgrey
out of the loop is the answer from Postfix after "RCPT TO:" noticeably
quicker ?

Lionel