Where are you counting from? - query on CTM_People involves multiple queries not just one, so are you just counting time from the "main" query to the next or the total time to process all queries for that operation?
Ours 329ms (from main to last query in operation) - 357,000+ total records - SQL 2008 remote cluster. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -----Original Message----- 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" The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
