QUESTION POSED ON: 25 January 2007
I created one table ContentTable(path varchar2(255),doc_format
varchar2(6),ResourceData Blob). The last column has actual text and binary data.
Case 1: I am bulk uploading in this table. My insertion speed is
100 mbps.
Case 2: I'm bulk uploading data in the same table but I have defined a Context
index on the last column (defined with no sync option, not real-time indexing).
The Insertion speed goes down to 15 mbps.
In both the cases, initially there is no data and I have inserted only 1GB of data.
I agree that when we define a text index then Oracle text maintains
internal pending queue for all incoming inserts, but that job does not seem
to be heavy. And even indexing is not going on during insertion because it
is offline.
My question is why the insertion speed goes down from 100 mbps to 15 mbps by
the just defined offline context index which is not running.
Thanks in advance.
|
