Re: Inserting and accessig Image (bmp) data in an SQL 2005 database.



If you are using TADOTable and you have image (blob) fields, you will soon
have memory problems. TadoTable opens the whole file into memory everytime
you open it. as it grows and as the images grow in size you will find that
performance will first go into the toilet and second finally come to a
complete halt. TadoTable is for backward compatibility only. You should
switch to tadodataset as soon as you can do this ...


(qryDocuments.fieldbyname('docimg') as tBlobField).loadfromfile(
'xxx.bmp' );






.