RE: [PEAR-DEV] MDB - Delete LOB

> From: Manuel Lemos [mailto:mlemos@acm.org] > Sent: Sunday, June 08, 2003 10:54 PM > Binary strings are not suitable as large objects containers because you > have to paste their whole contents in the query that creates or updated > them. This means if it would not exceed your PHP memory limit, it would > probably crash your Web server processes when you tried to insert large > data. > > MySQL already has this problem. MS-SQL and other databases accessed via > ODBC API are in worst situation because the data has to be encoded in > hexadecimal (double the size) to be inserted via SQL. PostgreSQL has > objects that you can use to store large amounts of data streaming it to > the server. > > Although PostgreSQL objects are not perfect, I think they are better to > store large objects than having to deal with the problems of pasting > large data in SQL queries. Yeah, but it would probably nice to provide a mechanism to delete these objects within the driver. This sounds like the way to go then. Regards, Lukas