I remember a discussion awhile back regarding field 112 and 'Enable Multiple Assign Groups' on the configuration tab of the server. If checked it needs to do the type of like query you are describing. If unchecked it however does an = statement instead....check if this is enabled...and if so....do you need that field to have multiple values...and if not....try disabling it and see if these issues seem to go away
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Flynn, Tom (MTO) Sent: Wednesday, May 10, 2006 10:47 AM To: [email protected] Subject: Limiting Query Results Hello All, Our Remedy Admin Group is investigating methods to limit intermittent performance problems on our custom ARS 6.3 p13/ MSSQL 2000 infrastructure. Specifically, does anyone know of a way to limit query results on a per form basis? We've recently implemented useage of field 112 on our Helpdesk form (approx 250k rows), which definitely adds overhead on select statements and seems to be the cause of increased overall processing 'noise'. Bottom line is that we can't rely on users to run smart queries against this form, so we need a way to prevent system slowdowns through workflow or some other setting. Just for the heck of it to show what's going on with C112, here's a portion of what we see in SQL Profiler during a query: SELECT T285.C1,T285.C1,C7,C600000495,C600000065,C600000122,C600000024,C600000137,T2 85.C1,C600000122 FROM T285 WITH (NOLOCK) WHERE (((T285.C112 LIKE '%;''CrombJo'';%') OR ((T285.C112 LIKE '%;0;%') OR ((T285.C112 LIKE '%;53091;%') OR ((T285.C112 LIKE '%;53100;%') OR ((T285.C112 LIKE '%;53091;%') OR (T285.C112 LIKE '%;50001;%')))))) We're not interested in disabling the global 'Allow Unqualfied Searches' setting, Results List data chunking isn't what we're after either, and data archiving is a few months away, and may not matter. We're also in the process arranging testing p15 which reportedly addresses a 112 memory leak. If anyone knows a method to assist us, or if I missed something obvious it would be greatly appreciated - go easy on me, I'm a first time poster... Thanks, > Tom Flynn > ITSM Process Lead > e-Ontario OCCSD Servicedesk Project > Ontario Ministry of Government Services > E-mail: [EMAIL PROTECTED] > > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
