Re: [Sqlgrey-users] slow performance

[Beast <be...@i6...>]

Lionel Bouton wrote:
> 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.
> 

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)


-- 

--beast