Re: MDB - Delete LOB
| From: | Alexey Borzov | Date: | Mon, 09 Jun 2003 08:33:47 +0000 |
| Subject: | Re: MDB - Delete LOB | ||
| References: | 1 2 3 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-17192@lists.php.net to get a copy of this message | ||
Hi!
Manuel Lemos wrote:
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.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.