Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow!

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

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Thu, 21 Apr 2005 05:15:26 -0700 (PDT)
Message-ID: <20050421121527.97578.qmail@web52606.mail.yahoo.com>


Does this mean it is now much faster when you remove that bug?

XMLType insert (with or without LOB storage) is just measured in 100s, while standard inserts are measured in 1000s.

So inserting XMLType user types will take to say 10 times longer then normal data inserts :)

XMLType performances are crap even you say, do not parse, do not validate, just put it into CLOB.

Also the size of XML is not important here as how many of XML's you are inserting with import.

Anyway, it will be much slower with or without that memory leak.


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 Thu Apr 21 2005 - 08:19:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US