Page 1 of 1

Slow response with MYSQL db

Posted: 08.09.2006, 18:10
by aljosa.motore
I made a program like:

************************************************************
form1.Link_Query.SQL.clear;

form1.Link_Query.SQL.add('Select dok from racun_files where tip_dok LIKE ' + chr(39) +'easyracun'+ chr(39) + ' and id_dok LIKE ' +chr(39)+detail+chr(39));

form1.Link_Query.Active := true;

temp := form1.Link_Query.FieldByName('dok')).asstring;
************************************************************

So, the problem is that I have 90MB database file and if I use the last line (temp :=) then my program freez for 10 sec, without that there is not problem. What I want to do is to get data from that data field (data is text based)

P.S.: "dok" is field type "BLOB"

Thanks

Posted: 12.09.2006, 16:41
by Visor123
What for so to use BLOB-field ???
temp := form1.Link_Query.FieldByName('dok')).asstring;