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.

row size limitation

2 posts in Migration Last posting was on 2000-12-07 16:22:49.0Z
PETE MA Posted on 2000-12-07 06:11:59.0Z
From: "PETE MA" <pete.ma@haeco.com>
Subject: row size limitation
Date: Thu, 7 Dec 2000 14:11:59 +0800
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <dhFl$aBYAHA.71@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.migration
NNTP-Posting-Host: 168.70.218.253
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:349
Article PK: 1067773

is the row size limitation in 11.9.2 still 1962 bytes?
Also if i keep the same configuration when upgrading from 11.0.3 to 11.9.2,
any problems?
eg. memory, no. of user connection, no. of open objects
thanks


Bret Halford Posted on 2000-12-07 16:22:49.0Z
Message-ID: <3A2FB959.2EBFD358@sybase.com>
Date: Thu, 07 Dec 2000 09:22:49 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: ja,en
MIME-Version: 1.0
Subject: Re: row size limitation
References: <dhFl$aBYAHA.71@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.migration
Lines: 25
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:348
Article PK: 1067771


PETE MA wrote:

> is the row size limitation in 11.9.2 still 1962 bytes?
> Also if i keep the same configuration when upgrading from 11.0.3 to 11.9.2,
> any problems?
> eg. memory, no. of user connection, no. of open objects
> thanks

Yes, the row size limitation for tables with ALLPAGES lock scheme
(the default, 11.9.2 introduces DATAPAGE and DATAROW lock schemes as well)
remains 1962 bytes. The limit is a little smaller for the new lock shemes.

ASE 12.5 is going to allow larger row widths if you chose to use a larger
page size - but it is a little early to worry about it yet, the beta program
has
barely begun.

In general, the same configurations will probably be fine. If you start using
DATAROW locking on some tables, you may need to boost the number of
locks available. You will probably want to experiment with some tuning,
however -
you may be able to reap good performance gains by using the new parallelism
features.

-bret