** Load image from Table to DBImage so slow...........????

** Load image from Table to DBImage so slow...........????

Post by Dick Won » Sat, 14 Dec 1996 04:00:00


Hello,
   I got the following question in processing image..
I tried to load the image :
   DBImage1.Picture.LoadFromFile('c:\abc.bmp');

The image can load into the DBImage component but it takes a horrible times
(around 2-3 minutes in loading 1MB image).

I check that delphi send a request to MS-SQL 6.5 server to retrive data ,
MS-SQL 6.5 server then use the "READTEXT" / "WRITETEXT" command to save &
retrieve data. So I want to ask is it true that WRITETEXT or READTEXT only
can read/write 128K size at one time ?  so thats why it takes long time ???

Second , Can  I use other method to save/read  BLOB data  from SQL server
6.5 in fast mode ???
may be dbi- function ???

Please Help me.... Thanks
--