I have two topics to discuss. If you know anything about it
Ill 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
2. A customer has problem with performance on his SQL Any6.
He has a database and 50 users are connected and sending
there. He tries to solve the problem by setting parameters
amount of threads and tasks. Do you have any experience
this setting for database server? Is there big difference
performance between Any6 and Any9 or higher?
From: Ondrej Chlup
Subject: decomposition of SQL query and threads setting
X-Mailer: WebNews to Mail Gateway v1.1t
Content-Type: text/plain; charset="ISO-8859-1"
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
Xref: forums-1-dub ianywhere.public.general:7592
Article PK: 5991
From: Mark Culp <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
Subject: Re: decomposition of SQL query and threads setting
Content-Type: text/plain; charset=iso-8859-1
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
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
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).
SQLAnywhere Research and Development
Sybase iAnywhere Engineering