I captured a database log of searching using both ways. The where clause on each is identical and has the full case id in it. All of the SQL queries in the log are identical.
The total time for all the DB activity is pretty close too. It appears that the delay is occurring after all the DB activity; happening when the client is preparing to display the result. Any other ideas on logs I should compare or why displaying the result from the full id search is taking a lot longer? Thanks, Ken. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Nichols, Wesley D CTR USAF AFMC 72 CS/SCBAF Sent: Thursday, June 18, 2009 10:26 AM To: [email protected] Subject: Re: Search for full Case ID takes longer than just the number 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:[email protected]] On Behalf Of Cecil, Ken Sent: Thursday, June 18, 2009 9:03 AM To: [email protected] 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: [email protected] ARSlist: "Where the Answers Are"_ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" ******************************************************************* 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** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
