Maybe it will be interesting for somebody.
Next query is taking very short time:
select * from actlog where 'MM/DD/YYYY HH:MM:SS'< DATE_TIME
where 'MM/DD/YYYY HH:MM:SS' is completely specified date and time like
'08/25/2011 14:08:17'
In this case, it is possible to select data from ACTLOG for any required period
like "now - N minutes" just converting start time to text format.
Grigori G. Solonovitch
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Sims
Sent: Monday, August 22, 2011 2:30 PM
To: ADSM-L AT VM.MARIST DOT 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, 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Erwann SIMON
> Sent: Sunday, August 21, 2011 4:20 PM
> To: ADSM-L AT VM.MARIST DOT 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
> 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
Please consider the environment before printing this Email.
CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail
message and any attachments hereto may be legally privileged and confidential.
The information is intended only for the recipient(s) named in this message. If
you are not the intended recipient you are notified that any use, disclosure,
copying or distribution is prohibited. If you have received this in error
please contact the sender and delete this message and any attachments from your
computer system. We do not guarantee that this message or any attachment to it
is secure or free from errors, computer viruses or other conditions that may
damage or interfere with data, hardware or software.
|