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, servername, sessid, session, process, date_time \
from actlog \
where DATE(DATE_TIME)=CURRENT_DATE and date_time >(current_timestamp - 3
minutes)
Add Order By if you want.
Richard Sims
On Aug 22, 2011, at 3:08 AM, Grigori Solonovitch wrote:
> Thank you very much Erwann, but it does not help. There is no visible
> improvement.
>
> Grigori G. Solonovitch
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of
> Erwann SIMON
> Sent: Sunday, August 21, 2011 4:20 PM
> To: [email protected]
> Subject: Re: [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 ..."
>
> Best regards / Cordialement / مع تحياتي
> Erwann SIMON
>
>
> Le 21/08/2011 12:38, Grigori Solonovitch a écrit :
>> 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_time)minutes as decimal)<3
>> ORDER BY date_time DESC
>>
>> Thank you very much in advance.
>>
>> Grigori G. Solonovitch
