Normally for very large XML documents you'd use SAX to process them.
Given that you have a relational database, why not access the XML information
in smaller documents? Does the data really have to be that monolithic? Also
are you using the 9i r2 XML data types from Oracle?
Ken Ross
Ph: +61 7 32359370
Mob: +61 (0)419 772299
Email: Ken(_dot_)Ross(_at_)iie(_dot_)qld(_dot_)gov(_dot_)au
-----Original Message-----
From: Scott Purcell [mailto:spurcell(_at_)vertisinc(_dot_)com]
Sent: Thursday, 16 January 2003 12:40 AM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] Register Marks, Funny Character Problems
Hello,
I have been given a project, in which I am creating xml files of data coming
from our Oracle db. The files get quite large, as a xml document we have seen
the ASCII files get up to 50MB.
We are NOT using dom to assemble these xml files, due to the fact that dom puts
the whole document into memory, and since this is a web app, will probably
bring down the web server.
The developer created some class files and basically is creating the xml by
printing the data to a text file.
First question: I know this is probably not the right way, but what should one
do when the files get huge like this?
Second question: The way we are doing this, there are trademark, and register
symbols in the database that are screwing up the xml when we try and parse it
later.
Does anyone have any insight into this problem arena?
Thanks,
Scott
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
IMPORTANT: This email (including any attachments) may contain confidential,
private or legally privileged information and may be protected by copyright.
You may
only use it if you are the person(s) it was intended to be sent to and if you
use it in an
authorised way. No one is allowed to use, review, alter, transmit, disclose,
distribute,
print or copy this e-mail without appropriate authority.
If this e-mail was not intended for you and was sent to you by mistake, please
telephone or e-mail me immediately, destroy any hard copies of this e-mail and
delete
it and any copies of it from your computer system. Any legal privilege and
confidentiality attached to this e-mail is not waived or destroyed by that
mistake.
It is your responsibility to ensure that this e-mail does not contain and is
not affected
by computer viruses, defects or interference by third parties or replication
problems
(including incompatibility with your computer system).
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list