I think you are falling into a QBE match issue. When you use just the number the system pre-pends the prefix onto the number and does an equal search. When you put in the entire number I bet it takes the default QBE for the field. You can verify this by looking at the SQL logs.
Wes -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Cecil, Ken Sent: Thursday, June 18, 2009 9:03 AM To: arslist@ARSLIST.ORG Subject: Search for full Case ID takes longer than just the number ** Anybody have an idea on why it is taking 10 times longer to search for a record using the fully qualified ID than it does when searching using just the number? This is only when searching using query by example (entering the id on the form). Any ideas on where to look/troubleshoot? Search examples: Query By Example using the Case ID field (field 1 on this form) 135303 ...takes about 9 seconds. HD0135303 ...takes about 90 seconds to return?????????? Advanced search using criteria instead... 'Case ID+' LIKE "%135303" ...Takes 95 seconds. 'Case ID+' = "HD0135303" ...Takes 10 seconds. It is like it is having to do a full table scan even though this field is obviously indexed. Also, from what I can tell it is just on the Help Desk form; other forms perform well either way. For what it is worth, I am working with ARS 6.0 and Help Desk ITSM 5.6 Thanks, Ken. ******************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
