Slow response with MYSQL db

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
aljosa.motore
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 08.09.2006, 18:03

Slow response with MYSQL db

Post 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
Visor123
Fresh Boarder
Fresh Boarder
Posts: 22
Joined: 07.09.2005, 10:20
Location: Dnepr

Post by Visor123 »

What for so to use BLOB-field ???
temp := form1.Link_Query.FieldByName('dok')).asstring;
Post Reply