Re: CLOB search

Does FTS cost extra? What’s the downside/ drawbacks? > On 10. May 2019, at 15:25, LJ LongWing wrote: > > If you have a CLOB, performance of searches is going to suck if doing it > directly at the DB level, if it's even possibleadding FTS to the field > indexes the field with a lucene

Re: CLOB search

If you have a CLOB, performance of searches is going to suck if doing it directly at the DB level, if it's even possibleadding FTS to the field indexes the field with a lucene index (FTS flat file), and a query against that field doesn't go to the DB, instead it does the flatfile index search,

Re: CLOB search

Is FTS avoidable? > On May 10, 2019, at 3:03 PM, LJ LongWing wrote: > > Would FTS help you in any way? I know it would help, but the question is are > you willing to make that change. > > On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz > wrote: > Hi All > > we

Re: CLOB search

Would FTS help you in any way? I know it would help, but the question is are you willing to make that change. On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz wrote: > Hi All > > we had to increase the size of a char field to over 4000 with huge > performance degradation when using this field

CLOB search

Hi All we had to increase the size of a char field to over 4000 with huge performance degradation when using this field for search. Does anyone know how to heal this? Would the Oracle 12 Text Option help? Thomas -- ARSList mailing list ARSList@arslist.org

Re: CLOB search

if you are on a modern version (9.x I know for sure, maybe even 8.1.02, but not 100% sure on that one) FTS is included with Remedy server...so, no extra monetary costthe cost you will bear is that of hard disk spacedepending on what all you have that's currently set to be indexed, your fts

Re: Re: CLOB search

Peter, Thank you for thatI thought that the FTS got included with the specific version of Remedy where 'Hub and Spoke' model was introducedthanks for the clarification. On Fri, May 10, 2019 at 7:47 AM Adams, Peter wrote: > About FTS pricing: > > > > That depends on the pricing model

Re: Re: CLOB search

About FTS pricing: That depends on the pricing model that you’re using to license Remedy. The vast majority of our customers are on one of solution pricing models that were first introduced in 2007. For those customers, FTS is no extra cost. Only the few customers that remain on the very

Re: Re: Re: CLOB search

In general, it’s pricing model dependent. However, I should have qualified my earlier statement: the “no extra cost” in the newer pricing models applies only, if you are on versions 7.6.03 or higher, which hopefully everyone is. Has nothing to do with Hub & Spoke. If you recall, in 7.6.03 we

Re: Re: Re: CLOB search

ahmy historical recollection of the when/why of FTS being included was wrong then :) On Fri, May 10, 2019 at 8:12 AM Adams, Peter wrote: > In general, it’s pricing model dependent. > > > > However, I should have qualified my earlier statement: the “no extra cost” > in the newer pricing