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.

Database Size Reading Material

2 posts in General Discussion Last posting was on 2004-08-09 17:06:00.0Z
Steve Posted on 2004-08-09 16:36:26.0Z
Sender: 27e8.4117a695.1804289383@sybase.com
From: Steve
Newsgroups: ianywhere.public.general
Subject: Database Size Reading Material
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4117a80a.2801.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Aug 2004 09:36:26 -0700
X-Trace: forums-1-dub 1092069386 10.22.241.41 (9 Aug 2004 09:36:26 -0700)
X-Original-Trace: 9 Aug 2004 09:36:26 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3367
Article PK: 7272

I am currently upgrading customers from Adaptive Server
Anywhere 6.0.3 to SQL Anywhere 9.0.1, Windows based.

My tests on my computer show a certain database in Version 9
is extremely faster than an old version 6 datbase. However,
the customer is noticing the Version 6 was way faster than
9. He is running off an older computer and I'm thinking it
has something to do with page size (I used the 4096 option).

Can someone please supply info. that may be slowing his data
down transfering between the application (i.e. is page size
supported in certain areas of windows and not others).
Reading material or otherwise will be appreciated.


Breck Carter [TeamSybase] Posted on 2004-08-09 17:06:00.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Database Size Reading Material
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <u0bfh019abrk7t9uuk6kdrbefhtrrg04ag@4ax.com>
References: <4117a80a.2801.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 12.24.172.2
X-Original-NNTP-Posting-Host: 12.24.172.2
Date: 9 Aug 2004 10:06:00 -0700
X-Trace: forums-1-dub 1092071160 12.24.172.2 (9 Aug 2004 10:06:00 -0700)
X-Original-Trace: 9 Aug 2004 10:06:00 -0700, 12.24.172.2
Lines: 33
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3368
Article PK: 7274

It is possible the physical file is highly fragmented for the version
9 database, and/or that the version 9 engine is being started with
very little cache memory. The 4K page size should be OK no matter
*what* version of the operating system is used (unless it is DOS 2.x
on a 10M drive, but we can rule that out :)

The best reading material is the Help, and Chapter 10 Tuning in the
book referenced below.

Breck

On 9 Aug 2004 09:36:26 -0700, Steve wrote:

>I am currently upgrading customers from Adaptive Server
>Anywhere 6.0.3 to SQL Anywhere 9.0.1, Windows based.
>
>My tests on my computer show a certain database in Version 9
>is extremely faster than an old version 6 datbase. However,
>the customer is noticing the Version 6 was way faster than
>9. He is running off an older computer and I'm thinking it
>has something to do with page size (I used the 4096 option).
>
>Can someone please supply info. that may be slowing his data
>down transfering between the application (i.e. is page size
>supported in certain areas of windows and not others).
>Reading material or otherwise will be appreciated.

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com