Hi, I have a table: CREATE TABLE http_refer( rid int unsigned auto_increment, refer varchar(255), unique index(rid), unique index(refer) ); It is filled with referrers from our webserver log and has 4138 rows. Today I've tried to execute: mysql> select max(length(refer)) from http_refer; or mysql> select min(length(refer)) from http_refer; but both queries just hanged and I had to kill them. Some of table rows is full filled with urls from search engines with long list of parameters. My server system : Linux 2.2.18 mysql-3.23.33-log Any comments? Saulius Gurklys mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php