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.

Difference on Execution/CPU/Clock Time

3 posts in General Discussion Last posting was on 2010-06-01 12:32:00.0Z
Sergio Diogo Posted on 2010-06-01 07:34:21.0Z
Sender: 3ec1.4c04b71a.1804289383@sybase.com
From: Sergio Diogo
Newsgroups: sybase.public.ase.general
Subject: Difference on Execution/CPU/Clock Time
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c04b7fd.3ede.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Jun 2010 00:34:21 -0700
X-Trace: forums-1-dub 1275377661 10.22.241.41 (1 Jun 2010 00:34:21 -0700)
X-Original-Trace: 1 Jun 2010 00:34:21 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29273
Article PK: 78507

Hi,

I would like to understand what is the real difference
between the values displayed on: Execution Time, CPU Time
and Clock Time.

thanks in advance,
Regards,
Sérgio Diogo


Venky Posted on 2010-06-01 09:58:33.0Z
Sender: 4522.4c04d3f4.1804289383@sybase.com
From: Venky
Newsgroups: sybase.public.ase.general
Subject: Re: Difference on Execution/CPU/Clock Time
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c04d9c9.4620.1681692777@sybase.com>
References: <4c04b7fd.3ede.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Jun 2010 02:58:33 -0700
X-Trace: forums-1-dub 1275386313 10.22.241.41 (1 Jun 2010 02:58:33 -0700)
X-Original-Trace: 1 Jun 2010 02:58:33 -0700, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29275
Article PK: 78512

Clock Time value reflects the entire transaction, which
starts when Client-Library(TM) builds the query and ends
when Client-Library returns the information from Adaptive
Server.

Execution Time - The number of CPU ticks taken to execute
the query.

Cpu Time - The number of CPU ticks taken to execute the
query, converted to milliseconds.

> Hi,
>
> I would like to understand what is the real difference
> between the values displayed on: Execution Time, CPU Time
> and Clock Time.
>
> thanks in advance,
> Regards,
> Sérgio Diogo