> Actually, i have a parent table with 5 children tables and lots of records > that i must stream to an XML file. > with a big "select id, cast(multiset), cast(multiset), .., cast(multiset)" i > can stream from record to record without > having to cache or to make "buckets" of 1000. it works quite well.
That's what I thought. Sometimes, denormalisation is just so much faster. Next step, generate the XML in the database, directly using Oracle's XML support! ;-)
