Thanks all for the responses. We "figured out" our slowness. Turns out Oracle statistics had not been updated for 6+ months.
Now with 140,000 -- it is near instantaneous on Oracle. -John On Mon, Aug 22, 2011 at 9:20 AM, Andrew C Goodall <[email protected]>wrote: > 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 <[email protected]>: > > ** 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] > > _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" > -- 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] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
