On Wed, 15 Jan 2003, Andre John Cruz wrote: .. > besides...it's not really convenient having large objects inside your > database. i've only used open source db servers extensively and it's not > really good to store big objects (e.g. mail, with all your attachments > and stuff) inside it. mysql performance degrades big time. i don't know > what's the case with enterprise-strength stuff like oracle. most design > guides point to storing binary data as much as possible in the > filesystem, instead of the database. (of course there are some > applications wherein storing binary data in the db is better but maybe > mail storage isn't one of them :P)
one big advantage of storing the data in Oracle is the InterMedia support -- you can perform full-text queries on MSWord docs, PDF's, HTML, etc. that are stored as BLOB's inside Oracle. of course InterMedia is an extra-cost option for Oracle, which already costs a lot (InterMedia Text will roughly double the licensing cost!) --- Orlando Andico <[EMAIL PROTECTED]> Mosaic Communications, Inc. _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
