RE: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow!
- From: Martic Zoran <zoran_martic@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 21 Apr 2005 08:06:47 -0700 (PDT)
You said it is doing:
53MB of "XML Datatype" After 30 Min.
If your database is working at speed of 50 XMLType
inserts per second, then in 1800 seconds you will
insert 90,000 XMLTypes.
This mean if you have XMLType data that are in average
600 bytes that is exactly these 53M worth of data.
Not sure why are you talking in MB or GB while this is
not crazy critical for the speed of import. There are
other things there, like number of rows, ...
I am now confused, are you saying import is not
working at all?
Regards,
Zoran
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
