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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
