Re: Inserting and accessig Image (bmp) data in an SQL 2005 database.
- From: "Del Murray" <Del.Murray@xxxxxxxxxxxxxx>
- Date: Tue, 30 Oct 2007 04:31:39 -0500
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' );
.
- References:
- Inserting and accessig Image (bmp) data in an SQL 2005 database.
- From: Larry Killen
- Re: Inserting and accessig Image (bmp) data in an SQL 2005 database.
- From: Brian Bushay TeamB
- Re: Inserting and accessig Image (bmp) data in an SQL 2005 database.
- From: Larry Killen
- Inserting and accessig Image (bmp) data in an SQL 2005 database.
- Prev by Date: Re: Formatting output of TDBEdit
- Next by Date: Re: mdb file on internet
- Previous by thread: Re: Inserting and accessig Image (bmp) data in an SQL 2005 database.
- Next by thread: Re: ADO over Vista
- Index(es):