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.

about the ASE's max row per table

3 posts in Product Futures Discussion Last posting was on 2002-05-15 10:39:50.0Z
mzwang Posted on 2002-05-15 02:30:17.0Z
From: mzwang
Date: Tue, 14 May 2002 22:30:17 -0400
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: about the ASE's max row per table
Message-ID: <18A8C79574056C0A000DC27485256BBA.000DC2A485256BBA@webforums>
Lines: 4
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:480
Article PK: 93649

hi,

one of our custom wants to know our ASE's max row number per table, i don't
know if it can calculate by max size per database / max colum .


Roger Broadbent Posted on 2002-05-15 10:28:56.0Z
From: "Roger Broadbent" <RBroadbent@wilco-int.excise-this.com>
References: <18A8C79574056C0A000DC27485256BBA.000DC2A485256BBA@webforums>
Subject: Re: about the ASE's max row per table
Date: Wed, 15 May 2002 11:28:56 +0100
Lines: 23
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: <#b7kh0$#BHA.201@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: wilcohost-180.wilco-int.com 212.36.174.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:479
Article PK: 93647

You could calculate the number of rows per page, then multiply by the
maximum number of available data pages in a database of maximum size. This
would work for a heap table with no indexes, no blobs and a 100% fill-factor
on a database with no other objects, carefully created for maximum size.

This would have no relevance at all to real-world applications.

I think Sybase simply states that it is only limited by storage.

--
Roger Broadbent
Technical Consultant
Wilco International Ltd

<mzwang> wrote in message
news:18A8C79574056C0A000DC27485256BBA.000DC2A485256BBA@webforums...
> hi,
>
> one of our custom wants to know our ASE's max row number per table, i
don't
> know if it can calculate by max size per database / max colum .


Anthony Mandic Posted on 2002-05-15 10:39:50.0Z
Message-ID: <3CE23AF6.4A6A0788@start.com.au>
Date: Wed, 15 May 2002 20:39:50 +1000
From: Anthony Mandic <sp_am_block@start.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: about the ASE's max row per table
References: <18A8C79574056C0A000DC27485256BBA.000DC2A485256BBA@webforums> <#b7kh0$#BHA.201@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 16
NNTP-Posting-Host: 203.3.176.10
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:478
Article PK: 93648


Roger Broadbent wrote:
>
> You could calculate the number of rows per page, then multiply by the
> maximum number of available data pages in a database of maximum size. This
> would work for a heap table with no indexes, no blobs and a 100% fill-factor
> on a database with no other objects, carefully created for maximum size.
>
> This would have no relevance at all to real-world applications.
>
> I think Sybase simply states that it is only limited by storage.

I would think that the key you use would also tend to be a
limiting factor is it was poorly chosen.

-am © 2002