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.

decomposition of SQL query and threads setting

2 posts in General Discussion Last posting was on 2009-06-12 13:17:07.0Z
Ondrej Chlup Posted on 2009-06-04 12:49:27.0Z
Sender: a08.4a2530c1.1804289383@sybase.com
From: Ondrej Chlup
Newsgroups: ianywhere.public.general
Subject: decomposition of SQL query and threads setting
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a27c2d7.58dd.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: 4 Jun 2009 05:49:27 -0700
X-Trace: forums-1-dub 1244119767 10.22.241.41 (4 Jun 2009 05:49:27 -0700)
X-Original-Trace: 4 Jun 2009 05:49:27 -0700, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7592
Article PK: 5991

Hello everybody,
I have two topics to discuss. If you know anything about it
I’ll be pleased if you share your knowledge with me.
1. Are there any rules which describe how SQL query is
decomposed in SQL any or do you know any document which
describes that?
2. A customer has problem with performance on his SQL Any6.
He has a database and 50 users are connected and sending
queries
there. He tries to solve the problem by setting parameters
of
amount of threads and tasks. Do you have any experience
with
this setting for database server? Is there big difference
in
performance between Any6 and Any9 or higher?


Mark Culp Posted on 2009-06-12 13:17:07.0Z
Message-ID: <4A325552.44D80709@iAnywhere.com>
From: Mark Culp <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: decomposition of SQL query and threads setting
References: <4a27c2d7.58dd.1681692777@sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 12 Jun 2009 06:17:07 -0700
X-Trace: forums-1-dub 1244812627 10.22.241.152 (12 Jun 2009 06:17:07 -0700)
X-Original-Trace: 12 Jun 2009 06:17:07 -0700, vip152.sybase.com
Lines: 51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7616
Article PK: 6010

Ondrej, FWIW it is generally a good idea to post only one
question per posting since readers may have answers to one
of your questions and not the other, and once someone does
post an response, some readers may assume that the question
was answered and skip over the thread.

Re. #1: I do not believe that there is a document that describes
the exact rules of how SQL Anywhere decomposes and executes a
query. The exact process that is used is complex and changes
from release to release (and even within a release from one
build to another as various improvements are made to the query
optimizer).

Re. #2: The performance difference that you will see between
ASA 6 and SA 9 will be dependent on your workload and therefore
no one can answer this question. Note however that there have
been a great number of advances made between ASA 6 and SA 9
in terms of query optimization, and therefore I would expect
that SA 9 would perform better on complex queries.

Both ASA 6 and SA 9 should easily handle 50 users,... but (again)
it will depend on the workload of those users.

One thing to note is that ASA 6 has long been archived
and is no longer supported by SA engineering (i.e. no further
bug fixes). SA 9 is still supported, but is due to be archive
next January (of 2010).
--
Mark Culp
SQLAnywhere Research and Development
Sybase iAnywhere Engineering
-------------------------------------------------------------------------

Ondrej, Chlup wrote:
>
> Hello everybody,
> I have two topics to discuss. If you know anything about it
> I’ll be pleased if you share your knowledge with me.
> 1. Are there any rules which describe how SQL query is
> decomposed in SQL any or do you know any document which
> describes that?
> 2. A customer has problem with performance on his SQL Any6.
> He has a database and 50 users are connected and sending
> queries
> there. He tries to solve the problem by setting parameters
> of
> amount of threads and tasks. Do you have any experience
> with
> this setting for database server? Is there big difference
> in
> performance between Any6 and Any9 or higher?