Tanel, if you use oracle to read BFILE's, you're no faster then by reading normal LOB's, because the mechanism is exactly the same: DBMS_LOB.READ into a buffer and buffer sent to you through Oracle*Net. The only way that you can be faster then that is to read the file name from a normal VARCHAR2 variable and then bypass oracle in accessing that file, and access it through some non-oracle mechanism,typically NFS or CIFS (Samba). Oracle database is created for reading structured tables by means of SQL, not for reading plain files. To read a plain file, you will use software designed exactly for that purpose. It's called "file system". Both NFSv3 and Samba V2 can beat oracle hands down in speed of reading/writing files to a remote node. What Samba and NFS cannot do is to retrieve record sets from those files using SQL. They can help you to bulk read the file into a document processor and nothing more. if speed is all that matters, you read the file name from oracle and then read the file by using appropriate tools like NFS, Samba or something else.
-- Mladen Gogala Oracle DBA -----Original Message----- Tanel Poder Sent: Thursday, August 21, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Hi! > Of course, you could give IFS a shot. I would still go with CLOBS if > I were you. You can do bfiles, but hten you have to set NFS server and > you can retrieve the document only if you have access to something > called /docs/oracle/bfile or similar, and that is rather hard to do > from an NT station. You can also store an ASCII file as an external You can read BFILEs without having client access to the file. As long Oracle has access to the file, it can open it & stream it to you. But if you want write access to these files you have to do it from OS or with utl_file or similar packages. Gets too complicated to use if your end users want to modify those docs, but it could work if you're loading your doc's once and they are only read afterwards. But yes, internal lobs can be fast if implemented properly. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
