Yes, it is a known issue with FTS specifically. The original defect was logged against FTS and the situation where the performance issue was encountered was during an internal (to BMC) test of FTS.
-David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Tuesday, February 07, 2012 7:26 AM To: [email protected] Subject: Re: 7.6.04 SP3 - SW00391781 Hi, It might explain things if it is related to FTS (Full Text Search). It did not specifically say so though... Best Regards - Misi, RRR AB, http://rrr.se > Misi, > I remember this issue specifically with the Full text search. Do you > know if it is related to that or specifically the DB? > > Sent from my iPhone > > On Feb 7, 2012, at 10:06 AM, Misi Mladoniczky <[email protected]> wrote: > >> Hi, >> >> In the "Known issues in the AR System server 7.6.04 Service Pack 3" I >> found this thing: >> >> SW00391781 >> In BMC Remedy AR System, the search operation using the leading wildcard >> character (%) is not as efficient as a complete string search or a >> trailing wildcard search. >> For example, search for the %block string is less efficient than a >> search >> for either the block or block% strings. >> To fix the issue, contact BMC Software Customer Support. >> --- >> >> I thought that this was all due to database issues when doing LIKE >> searches. Indexes was never used when doing trailing searches. How can >> this be "fixed"? >> >> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) >> >> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): >> * RRR|License - Not enough Remedy licenses? Save money by optimizing. >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy >> logs. >> Find these products, and many free tools and utilities, at >> http://rrr.se. >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
