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
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
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