Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Execution time

2 posts in General Discussion Last posting was on 2007-11-08 02:20:35.0Z
Gareth Davies Posted on 2007-11-05 14:51:34.0Z
From: Gareth Davies <gruff@sitemaker.cc>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Execution time
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
X-Original-NNTP-Posting-Host: 87-194-125-184.bethere.co.uk
Message-ID: <472f2df6$1@forums-1-dub>
Date: 5 Nov 2007 06:51:34 -0800
X-Trace: forums-1-dub 1194274294 87.194.125.184 (5 Nov 2007 06:51:34 -0800)
X-Original-Trace: 5 Nov 2007 06:51:34 -0800, 87-194-125-184.bethere.co.uk
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:519
Article PK: 1088204

It would be really useful if Workspace reported the time taken for a
given statement or procedure to execute. I've switched on the
'Statistics Time' options in the Connection Level Options but the
results are uninterpretable.


Samir Nigam Posted on 2007-11-08 02:20:35.0Z
From: "Samir Nigam" <samir_dot_nigam@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <472f2df6$1@forums-1-dub>
Subject: Re: Execution time
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: snigamxp.sybase.com
X-Original-NNTP-Posting-Host: snigamxp.sybase.com
Message-ID: <47327273@forums-1-dub>
Date: 7 Nov 2007 18:20:35 -0800
X-Trace: forums-1-dub 1194488435 10.22.85.206 (7 Nov 2007 18:20:35 -0800)
X-Original-Trace: 7 Nov 2007 18:20:35 -0800, snigamxp.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:523
Article PK: 1088207

In case you haven't tried this already, you can turn on "Display Result in
Single Tab" option (on the top right of the SQL Results view), then at least
each execution will be followed by the time statistics.

Regards,
Samir

"Gareth Davies" <gruff@sitemaker.cc> wrote in message
news:472f2df6$1@forums-1-dub...
> It would be really useful if Workspace reported the time taken for a given
> statement or procedure to execute. I've switched on the 'Statistics Time'
> options in the Connection Level Options but the results are
> uninterpretable.