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.

Performance: 8.0 -> 8.0.2

3 posts in General Discussion Last posting was on 2003-04-23 19:35:11.0Z
Tim_Beck Posted on 2003-04-22 21:42:51.0Z
From: Tim_Beck
Date: Tue, 22 Apr 2003 17:42:51 -0400
Newsgroups: ianywhere.public.general
Subject: Performance: 8.0 -> 8.0.2
Message-ID: <E10752AD4C7BCD8C0077478185256D10.0077479085256D10@webforums>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:922
Article PK: 3308

Hello,

I've got several customers who've upgraded from ASA 7 to 8 and noticed a
performance impact in that indexes appeared to be needed where none were
needed before. I've also personally experienced (as have several of our
customers) a performance impact when going from 8.0 to 8.0.2. Did I miss a
setting or is there any thing I should do?

Thanks, in advance, for your help.

Tim Beck
JDS Solutions Corporation


Robert Waywell Posted on 2003-04-23 19:02:43.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <E10752AD4C7BCD8C0077478185256D10.0077479085256D10@webforums>
Subject: Re: Performance: 8.0 -> 8.0.2
Date: Wed, 23 Apr 2003 15:02:43 -0400
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <uRErWtcCDHA.331@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:927
Article PK: 3311

I would be surprised to see a negative performance impact moving from
8.0.0 to 8.0.2. There are some performance benefits in 8.0.2 that you won't
see without an unload/reload to upgrade the db file from the 8.0.0 format,
but I don't expect to see any performance degradations. If you are seeing a
performace drop, then we would like to see the reproducible submitted to
Tech Support so that we can investigate it and address any issues.
In upgrading from 7.x to 8.x, you do need to perform an unload/reload to
upgrade the file format. Performance is likely to suffer if you don't do the
unload/reload. Again, we would like to get reproducible examples of any
performance issues that persist in 8.0.2 so that we can address them.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Tim_Beck> wrote in message
news:E10752AD4C7BCD8C0077478185256D10.0077479085256D10@webforums...
> Hello,
>
> I've got several customers who've upgraded from ASA 7 to 8 and noticed a
> performance impact in that indexes appeared to be needed where none were
> needed before. I've also personally experienced (as have several of our
> customers) a performance impact when going from 8.0 to 8.0.2. Did I miss a
> setting or is there any thing I should do?
>
> Thanks, in advance, for your help.
>
> Tim Beck
> JDS Solutions Corporation


Glenn Paulley Posted on 2003-04-23 19:35:11.0Z
Date: Wed, 23 Apr 2003 15:35:11 -0400
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: Performance: 8.0 -> 8.0.2
References: <E10752AD4C7BCD8C0077478185256D10.0077479085256D10@webforums>
In-Reply-To: <E10752AD4C7BCD8C0077478185256D10.0077479085256D10@webforums>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <eKbU2AdCDHA.280@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: paulley-xp.sybase.com 172.31.141.96
Lines: 41
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:930
Article PK: 3313


Tim_Beck wrote:
> Hello,
>
> I've got several customers who've upgraded from ASA 7 to 8 and noticed a
> performance impact in that indexes appeared to be needed where none were
> needed before. I've also personally experienced (as have several of our
> customers) a performance impact when going from 8.0 to 8.0.2. Did I miss a
> setting or is there any thing I should do?
>
> Thanks, in advance, for your help.
>
> Tim Beck
> JDS Solutions Corporation

The default setting for OPTIMIZATION_GOAL changed from FIRST-ROW in
8.0.0 to ALL-ROWS in 8.0.2, which may affect the access plans that you
are now seeing. As Rob stated in his post, I would expect to see mainly
performance improvements with 8.0.2 rather than a regression.

Of additional interest may be the support in 8.0.2 for clustered
indexes, which can dramatically improve response time for certain
queries (obviously depending on your schema and the characteristics of
the instance). An unload/reload to an 8.0.2 format database is necessary
to allow clustered indexes to be created.

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer