: John Sundbergmailto:john.sundb...@kineticdata.com
Sent: Thursday, September 01, 2011 1:31 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
** True... good suggestion.
Fundamentally - I was looking
: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
**
Joe,
well, I disagree with your rationale... actually because it is not a large
table, you can pin in it memory.
Generally speaking, you only pin into memory look-up tables that are used
heavily
08, 2011 12:15 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
**
Joe,
well, I disagree with your rationale... actually because it is not a large
table, you can pin in it memory.
Generally
Request System discussion list(ARSList) [
arslist@ARSLIST.ORG] on behalf of Joe Martin D'Souza [jdso...@shyle.net]
*Sent:* Thursday, September 08, 2011 12:33 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Performance question CTM:People timing
**
Yes I agree you would want to avoid pinning
@ARSLIST.ORG] On Behalf Of patrick zandi
Sent: Thursday, September 08, 2011 1:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
** I have done this in the past:: pin user (T30 for me) table, this
will drop IO to database.. have see this alot..
On Thu, Sep 8, 2011
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
**
Does anybody know if there is a similar option for SQL Server 2008?
Regards,
Andrew Goodall
Software Engineer 2 | Development Services | jcpenney . www.jcp.com
/
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, September 08, 2011 2:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
DBCC PINTABLE
Google
would that
have on pinning it to the database?
Joe
From: patrick zandi
Sent: Thursday, September 08, 2011 2:44 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
** I have done this in the past:: pin user (T30 for me) table
for indexes...
Joe
From: Guillaume Rheault
Sent: Thursday, September 08, 2011 2:36 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
**
Hi Joe,
I got to disagree with you again... but I guess this is what makes this ARS
.
From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on
behalf of Joe Martin D'Souza [jdso...@shyle.net]
Sent: Thursday, September 08, 2011 3:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
**
How would pinning a table impact
...@kineticdata.com]
Sent: Thursday, August 25, 2011 7:25 AM
To: arslist@ARSLIST.ORG
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
(ARSList) [arslist@ARSLIST.ORG] on
behalf of John Sundberg [john.sundb...@kineticdata.com]
Sent: Thursday, August 25, 2011 7:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
** Thanks all for the responses.
We figured out our slowness. Turns out Oracle statistics
, September 01, 2011 1:31 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
** True... good suggestion.
Fundamentally - I was looking for what is normal -- what we were seeing was
what we thought was slow. But - just
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 ago...@jcpenney.comwrote:
Where are you counting from? -
140 ms with 20.000 records, MS SQL 2005.
Terje
From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On
Behalf Of John Sundberg [john.sundb...@kineticdata.com]
Sent: 19 August 2011 23:34
To: arslist@ARSLIST.ORG
Subject: Performance question
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
(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Terje Moglestue
Sent: Monday, August 22, 2011 7:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
**
140 ms with 20.000 records, MS SQL 2005.
Terje
From: Action Request System
Typo ... 1.766 seconds instead of 1.766 ms :)
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, August 22, 2011 9:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance question CTM:People timing
**
I'm
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
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
20 matches
Mail list logo