11 2:30 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Query performance issue
Working with timestamps can be onerous. One sometimes has to be wily to
compensate for processing time. Try:
select msgno, severity, message, originator, nodename, ownername, schedname, \
domainname, serv
On Aug 22, 2011, at 2:17 PM, Grigori Solonovitch wrote:
> Thank you very much, Richard. This query is much faster and gives the same
> result from data point of view.
> I have only question about period of time from 00:00:00 till 00:02:59.
> Is this query correct for mentioned period of time?
>
: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Richard Sims
Sent: Monday, August 22, 2011 2:30 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Query performance issue
Working with timestamps can be onerous. One sometimes has to be wily to
compensate for processing time. Try
e-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Erwann
SIMON
Sent: Sunday, August 21, 2011 4:20 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Query performance issue
Hi Grigori,
Try to first add a clause that limit the scope of the search to avoid
calculatio
G. Solonovitch
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
> Erwann SIMON
> Sent: Sunday, August 21, 2011 4:20 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Query performance issue
>
> Hi Grigori,
>
> Tr
: [ADSM-L] Query performance issue
Hi Grigori,
Try to first add a clause that limit the scope of the search to avoid
calculation on the entire actlog table, something like "... where
date(current_timestamp)=current_date and
cast((current_timestamp-date_time)minutes as decimal)<3 ..."
Hi Grigori,
Try to first add a clause that limit the scope of the search to avoid
calculation on the entire actlog table, something like "... where
date(current_timestamp)=current_date and
cast((current_timestamp-date_time)minutes as decimal)<3 ..."
Best regards / Cordialement / مع تحياتي
Er
TSM Client 6.2.3.0 & TSM Server 5.5.5.
Is there any way to speed up next request?
select msgno, severity, message, originator, nodename, ownername, schedname,
domainname, servername, sessid, session, process, date_time as
date_time
from actlog
where cast((current_timestamp-date
