Typo ... 1.766 seconds instead of 1.766 ms :) From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Garrison, Sean (Norcross) Sent: Monday, August 22, 2011 9:23 AM To: [email protected] Subject: Re: Performance question CTM:People timing
** I'm a little confused on the question ... but to run the query via the DB takes 63 ms with ~49,000 people records. Oracle database. To run a query via Remedy 'Remedy Login ID' = "some user id" Takes ~ 1.766 ms to display fully. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Terje Moglestue Sent: Monday, August 22, 2011 7:06 AM To: [email protected] Subject: Re: Performance question CTM:People timing ** 140 ms with 20.000 records, MS SQL 2005. Terje ________________________________ From: Action Request System discussion list(ARSList) [[email protected]] On Behalf Of John Sundberg [[email protected]] Sent: 19 August 2011 23:34 To: [email protected] Subject: Performance question CTM:People timing ** How long does it take your DB system to resolve a query for an "exact match" on CTM:People where the query is 'Remedy Login ID' = "some user id" Also -- how many records are in your CTM:People -- and what DB are you using? Our sample system is 800ms - with 40,000 records... , Oracle 11g2 (Please get the timings from SQL log) -John -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax [email protected]<mailto:[email protected]> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
