RE: [PEAR-DEV] MDB - Delete LOB

> From: Alexey Borzov [mailto:borz_off@cs.msu.su] > Sent: Monday, June 09, 2003 10:34 AM > > Manuel Lemos wrote: > >> Maybe you can get rid of LOBs and just use the bytea fields? > > > > 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. > > > > ... > > > > 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. > > That's why I wrote 'maybe' in my post. ;] > The consensus can be that if the author of the original message does not > need to store binary data larger than few megabytes AND does not need to > have some kind of random access to it, then he can use binary strings. > If that is not true, he will have to use LOB API. Well I will try to seperate the datatype handling into a seperate class which can be modified/extended by the user. We will see how much overhead that creates, but I hear php5 will be a speed deamon ;-) Regards, Lukas