Slow response with MYSQL db
Posted: 08.09.2006, 18:10
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
************************************************************
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