RE: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow!

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 22 Apr 2005 07:31:39 -0700 (PDT)
Message-ID: <20050422143139.10553.qmail@web52606.mail.yahoo.com>

Chris,

I agree with you fully.

I just wanted to express how ugly performances are with XMLType object types regardless of using CLOB or XML schema as the storage for it.

The thing you cannot insert more then few hundreths of records with one XMLType column is what I pointed out. And that is with very hard core tuning :)

I know for many memory leak problems with XMLType. I needed to fight them myself with new and new patches.
But even without them it is still crap performances.

The current usability of XMLType in OLTP environment is very questionable with high level of inserts into XMLType.

Regards,
Zoran

• "Marquez, Chris" <CMarquez_at_aarp.org> wrote:
  >
  > Zoran,
  >
  > >>then in 1800 seconds you will
  > >>insert 90,000 XMLTypes.
  >
  > ||"much slower" vs. "not working"
  > ||>> Metalink Bug 3330477.
  

  ---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 22 2005 - 10:58:48 CDT