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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle text

Re: Oracle text

From: <cybotto_at_yahoo.com>
Date: 10 Oct 2005 15:29:23 -0700
Message-ID: <1128983363.329662.206150@g44g2000cwa.googlegroups.com>


To sync an index after each commit will make it very slow. Imagine all words in the document have an index and everytime all this words have to recreated again with all documents matching to all words in that document.

When you have a batch process and it is commiting after each record is normalized it can take forever and fragment that index a lot. Received on Mon Oct 10 2005 - 17:29:23 CDT

Original text of this message

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