Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Intermedia Text - Performance degradation over time
In article <c8i660$1ao$1_at_news5.tilbu1.nb.home.nl>, Frank van Bortel
says...
> >
> >
>
> Well Thomas Kyte is still using it quite happily for asktom.oracle.com.
> (http://asktom.oracle.com/pls/ask/f?p=4950:8:14791286290198708404::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:238814521769,)
> Well, maybe no anymore - the thread was started 4 years ago...
> Incidentally, there's a paper out on otn.oracle.com: "Oracle Text
> best practices" or similar, that states a reorg job with a time-out of
> 50 minutes, starting every hour would do nicely, and a full optimization
> every 24 hours or so. Using the ctx packages - not ctxsrv as external
> process.
> FWIIW, I'd be quite happy to use ctxsrv - if it's good enough for Tom,
> it's good enough for me.
> If you want you documents to be indexed 'near real time', or have
> a business need in that direction, I'd go for ctxsrv as process.
> If not - use a job and the packaged ctx procedures.
>
> The need for "optimization" stays - read the thread why
>
Thanks for the post - I'll take a look at the asktom article (although to be brutal he's unlikely to have implemented a 3rd party text management tool on asktom, is he!)
-- jeremyReceived on Thu May 20 2004 - 07:03:18 CDT