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 <arslist-boun...@arslist.org> on behalf of Thomas Miskiewicz <tmisk...@gmail.com> Reply-To: ARSList <arslist@arslist.org> Date: Friday, May 10, 2019 at 6:30 AM To: ARSList <arslist@arslist.org> Subject: [EXTERNAL] Re: CLOB search Does FTS cost extra? What’s the downside/ drawbacks? On 10. May 2019, at 15:25, LJ LongWing <lj.longw...@gmail.com<mailto:lj.longw...@gmail.com>> 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 <tmisk...@gmail.com<mailto:tmisk...@gmail.com>> wrote: Is FTS avoidable? On May 10, 2019, at 3:03 PM, LJ LongWing <lj.longw...@gmail.com<mailto:lj.longw...@gmail.com>> 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 <tmisk...@gmail.com<mailto:tmisk...@gmail.com>> 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 ARSList@arslist.org<mailto:ARSList@arslist.org> 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 ARSList@arslist.org<mailto:ARSList@arslist.org> 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 ARSList@arslist.org<mailto:ARSList@arslist.org> 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 ARSList@arslist.org<mailto:ARSList@arslist.org> 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 ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
