Hi all,
Here is the select I do on the following table. If file is a BLOB(2G), the request is very very slow (30-60s), even if there is only one line for the table. But if I replace BLOB(2G) by BLOB(5M) or BLOB(1G), the request becomes very fast.
Is there a reason ? Is there a workaround ?
I don't read the blob in my request (the blob is db_file.file, and it isn't used in the select) :
SELECT DISTINCT db_file.ID,db_file.name,db_file.reference,db_file.hash FROM db_file ORDER BY db_file.name;
And the slowliness of the request isn't related to the data filled in the blob, it is
Ok, I must have a problem, as I seem to have the same problem with mysql.
Thanks for your help.
Best regards.
Le lundi 09 janvier 2006 20:02 +0100, Grgoire Dubois a crit :
I don't read the blob in my request (the blob is db_file.file, and it isn't used in the select) :
SELECT