Peter, Thank you for that....I thought that the FTS got included with the specific version of Remedy where 'Hub and Spoke' model was introduced....thanks for the clarification.
On Fri, May 10, 2019 at 7:47 AM Adams, Peter <[email protected]> wrote: > 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 original pricing model for > Remedy – sometimes referred to as “green pricing” – would have to purchase > separate licenses for FTS. > > > > Peter > > > > > > *From: *ARSList <[email protected]> on behalf of Thomas > Miskiewicz <[email protected]> > *Reply-To: *ARSList <[email protected]> > *Date: *Friday, May 10, 2019 at 6:30 AM > *To: *ARSList <[email protected]> > *Subject: *[EXTERNAL] Re: CLOB search > > > > Does FTS cost extra? What’s the downside/ drawbacks? > > > On 10. May 2019, at 15:25, LJ LongWing <[email protected]> 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 possible....adding 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, > which is significantly more efficient and quicker than a db search.... > > > > So...yes it's avoidable if you don't want to take advantage of the things > that fts gives you....but your options of improving the effort with the DB > when searching a CLOB are very limited... > > > > On Fri, May 10, 2019 at 7:07 AM Thomas Miskiewicz <[email protected]> > wrote: > > Is FTS avoidable? > > > > On May 10, 2019, at 3:03 PM, LJ LongWing <[email protected]> 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 <[email protected]> > wrote: > > 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 > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist >
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
