52 ms with 52.000 records, Oracle 10.2 -- J
2011/8/20 John Sundberg <john.sundb...@kineticdata.com>: > ** 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 > john.sundb...@kineticdata.com > _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"
