Re: Re: Re: CLOB search

> > *From: *ARSList on behalf of LJ LongWing < > lj.longw...@gmail.com> > *Reply-To: *ARSList > *Date: *Friday, May 10, 2019 at 6:55 AM > *To: *ARSList > *Subject: *[EXTERNAL] Re: Re: CLOB search > > > > Peter, > > Thank you for thatI thought that

Re: Re: Re: CLOB search

3 we made a change in technology around FTS – moving to Lucene. Peter From: ARSList on behalf of LJ LongWing Reply-To: ARSList Date: Friday, May 10, 2019 at 6:55 AM To: ARSList Subject: [EXTERNAL] Re: Re: CLOB search Peter, Thank you for thatI thought that the FTS got incl

Re: Re: CLOB search

ng model for > Remedy – sometimes referred to as “green pricing” – would have to purchase > separate licenses for FTS. > > > > Peter > > > > > > *From: *ARSList on behalf of Thomas > Miskiewicz > *Reply-To: *ARSList > *Date: *Friday, May 10, 2019 at 6:30 AM

Re: Re: CLOB search

original pricing model for Remedy – sometimes referred to as “green pricing” – would have to purchase separate licenses for FTS. Peter From: ARSList on behalf of Thomas Miskiewicz Reply-To: ARSList Date: Friday, May 10, 2019 at 6:30 AM To: ARSList Subject: [EXTERNAL] Re: CLOB search Does FTS

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: 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

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

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

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