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 reading is the reason of the slow quare result.
Cheers, Akos Kiszely >SELECT kiterjesztes FROM fajl -> 12.43 !!! >SELECT fajl_id, fajl.letoltesek_szama FROM fajl -> 12.02sec >These all require a full table scan, and with that longblob in there it >is going to >take some time. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
