Re: Extreme slow table with longblob fields

2004-01-15 Thread Kiszely Ákos
Hi, It contains only 240 records... I have an another table without longblob field with much much more records, and the query result is less than one second with joins! 240 records with 11-15 sec... i think something wrong. If i start a query, MySQL read 30-40 MB to memory! Why? I think, this rea

Re: Extreme slow table with longblob fields

2004-01-15 Thread gerald_clark
Kiszely Ákos wrote: Hello list, I have a MySQL 3.23.49 under Debian Linux with this table: -- CREATE TABLE `fajl` ( `fajl_id` INTEGER(11) NOT NULL AUTO_INCREMENT, `fajl` LONGBLOB, `letoltesek_szama` INTEGER(11) NOT NULL DEFAULT '0', `filename` VARCHAR(80) DEFAULT NULL, `fajl_tipus

Extreme slow table with longblob fields

2004-01-15 Thread Kiszely Ákos
Hello list, I have a MySQL 3.23.49 under Debian Linux with this table: -- CREATE TABLE `fajl` ( `fajl_id` INTEGER(11) NOT NULL AUTO_INCREMENT, `fajl` LONGBLOB, `letoltesek_szama` INTEGER(11) NOT NULL DEFAULT '0', `filename` VARCHAR(80) DEFAULT NULL, `fajl_tipus` VARCHAR(20) DEF