One more way to make things even faster in Oracle is to "pin" the underlying T table into memory. Ask the DBA over there to do that
-Guilalume ________________________________ From: Action Request System discussion list(ARSList) [[email protected]] on behalf of John Sundberg [[email protected]] Sent: Thursday, August 25, 2011 7:25 AM To: [email protected] Subject: Re: Performance question CTM:People timing ** 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]<mailto:[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<http://www.jcp.com> -----Original Message----- 2011/8/20 John Sundberg <[email protected]<mailto:[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<tel:%28651%29%20556-0930>-work > (651) 247-6766<tel:%28651%29%20247-6766>-cell > (651) 695-8577<tel:%28651%29%20695-8577>-fax > [email protected]<mailto:[email protected]> > _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the > Answers Are"_ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug11 www.wwrug.com<http://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<http://www.arslist.org> attend wwrug11 www.wwrug.com<http://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]<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"
