Re: [PHPLIB-DEV] cvs commit From: Massimiliano Masserelli (negro <email protected>)
Date: 11/11/99

On Thu, Nov 11, 1999 at 05:54:26PM +0300, Kirill Maximov wrote:

 KIR> I tried to play with real Oracle BLOB support using Oracle7 API. And
 KIR> I failed to store value more then 2000 bytes to BLOB, though I used
 KIR> php Oracle API :(. It is not PHPLIB problem, but PHP. Or mine ;(

These are bad news. The postgres I've got here has some problems with
BLOBs, too, so I only coded the "generic" SQL implementations for BLOBs.

 KIR> May be you're right here. But I'm not sure that sessions data may
 KIR> require real BLOB (Binary and Large). Don't you want to store large
 KIR> images in session variables? Rather you'll store indices to database
 KIR> tables.

Well, it all depends on what we intend for "LARGE". Oracle seems to think
that >2k is "large", so... 8-)
 
 KIR> I had in mind possible search through BLOB data for the case when
 KIR> blob is text data. I even thought about some possible simple search
 KIR> function, which returns comma-separated id's of blobs found.

I don't think this would be a Good Thing(tm). This would require reading
ALL data from db, and this would be REAL slow. Instead, keep an index of
words in a separate table, and do your searches there...

Bye. 

--
     Massimiliano Masserelli       |     URL:    http://www.interim.it/
     Internet Images S.r.l.        |     Tel:    +39-051-3390671
     vicolo Viazzolo, 3            |     Fax:    +39-051-557890
     40124 - Bologna - Italy       |
-------------------------------------------------------------------------------
- L'ultima invenzione dei carabinieri?
- La torcia a batterie solari.
		-- Da it.hobby.umorismo
-
PHPLIB Developers Mailing List. Send messages to <phplib-dev <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-dev-request <email protected>> in
the body, not the subject, of your message.