Memory usage with Blobs
Posted: 01.08.2006, 15:27
Using Zeos 6.5.1 Delphi 7.1 and PostgreSQL 8.1.4
I've been looking at saving files into Bytea fields on PostgreSQL and have found a few problems. It seems that currently there is no way of extracting files from the database without first loading them into a dataset and thereby into memory.
Does anyone know of a way round this as I don't want the memory footprint of my application to go through the roof if I start using largish files?
Regards,
Ben
I've been looking at saving files into Bytea fields on PostgreSQL and have found a few problems. It seems that currently there is no way of extracting files from the database without first loading them into a dataset and thereby into memory.
Does anyone know of a way round this as I don't want the memory footprint of my application to go through the roof if I start using largish files?
Regards,
Ben