Can I modified the file being stored as a reference in oracle? I read, using BFILE type allows file to be used as read-only. Storing file on file system will make it server dependent. I have to access that file from multiple servers. Any thought.
-----Original Message----- From: Ben Groeneveld [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 12:04 PM To: JRun-Talk Subject: Re: Storing xml in oracle 8i Verma, if you are looking for performance, consider storing your large objects outside of oracle directly on the file system. You can store a reference to the file in oracle. Filesystems are pretty good at serving large stuff quickly - works great for us! Hope that helps, BenG. [EMAIL PROTECTED] wrote: >Hi All, >Has anybody ever faced a challenge to store bigger size xml or any other >file in the oracle 8i database. >I tried using the folloing schema- >CREATE TABLE ADVT_XML ( >XML_NAME VARCHAR(32), >XML_DATA CLOB) >STORAGE (INITIAL 10M NEXT 10M) >TABLESPACE ASI_DATA >LOB (XML_DATA) STORE AS advt_xml_lob >(TABLESPACE asi_test DISABLE STORAGE IN ROW >STORAGE (INITIAL 5M NEXT 5M) >CHUNK 32 >PCTVERSION 0 >NOCACHE LOGGING ); > > >But I could save only 9k out of 15k file. And took almost 3 minutes to save. >Has anybody ever done this? > >Thanks > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
