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.

Maxium Number of Records

5 posts in QAnywhere Last posting was on 2010-03-08 22:41:53.0Z
POS Posted on 2010-02-11 03:54:19.0Z
Sender: 237.4b737eaf.1804289383@sybase.com
From: POS
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Maxium Number of Records
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b737f6b.26c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Feb 2010 19:54:19 -0800
X-Trace: forums-1-dub 1265860459 10.22.241.41 (10 Feb 2010 19:54:19 -0800)
X-Original-Trace: 10 Feb 2010 19:54:19 -0800, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:324
Article PK: 10523

Hello,

I am using PixelPoint POS v10 software. The database is SQL
Anywhere Network Server Version 10.0.1.3415. I want to know
the MAXIUM number of records any one table can have and also
at what point will the software experience slow response
times because of the number of records. Also, what is the
maximum amount of RAM the SQL engine will support? The
maximum amount of CPU power?


Chris Keating (Sybase iAnywhere) Posted on 2010-02-11 13:42:59.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: Maxium Number of Records
References: <4b737f6b.26c.1681692777@sybase.com>
In-Reply-To: <4b737f6b.26c.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b740963$1@forums-1-dub>
Date: 11 Feb 2010 05:42:59 -0800
X-Trace: forums-1-dub 1265895779 10.22.241.152 (11 Feb 2010 05:42:59 -0800)
X-Original-Trace: 11 Feb 2010 05:42:59 -0800, vip152.sybase.com
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:325
Article PK: 10522

This is discussed in the documentation - search for "limitations"
keyword in the Index of the help file.

The max rows / table is 4096 × 2^28.

Performance of a database is more likely to be impacted by poor schema
design, query implementation, and operating environment than the number
of rows in a table.

Cache size (the memory aspect that you are interested in a database
environment) is dependent on the OS. The "limitation" reference covers
this at a high level but also look at -cl, -ch, -c, and -cw engine
option documentation for further details.

The number of CPUs that the engine can support is limited by licensing.
SQL Anywhere has no restriction of the actual 'processing' speed of the
chip.

POS wrote:
> Hello,
>
> I am using PixelPoint POS v10 software. The database is SQL
> Anywhere Network Server Version 10.0.1.3415. I want to know
> the MAXIUM number of records any one table can have and also
> at what point will the software experience slow response
> times because of the number of records. Also, what is the
> maximum amount of RAM the SQL engine will support? The
> maximum amount of CPU power?


peter Posted on 2010-03-08 22:41:53.0Z
Reply-To: "peter" <peter@pixelpointpos.com>
From: "peter" <peter@pixelpointpos.com>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
References: <4b737f6b.26c.1681692777@sybase.com> <4b740963$1@forums-1-dub>
Subject: Re: Maxium Number of Records
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b957d31$1@forums-1-dub>
Date: 8 Mar 2010 14:41:53 -0800
X-Trace: forums-1-dub 1268088113 10.22.241.152 (8 Mar 2010 14:41:53 -0800)
X-Original-Trace: 8 Mar 2010 14:41:53 -0800, vip152.sybase.com
X-Authenticated-User: innsbruck_beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:330
Article PK: 18810

The number would be 1,099,511,627,776. Which is gigantic number , if you had
1000 stores, running for 30 year ( 10,000 days ) and selling 10,000 line
items per day ( POSDETAIL table , very busy store ) that woudl be
100,000,000,000 records which would be 10% of the limit.

Unless some SQL request use unindex field size of the DB shoudl be offf
little influence. If you coudl specify what specificaly is slow, I woudl be
willing to look into it.

"Chris Keating (Sybase iAnywhere)" <keating_nospam@sybase.com> wrote in
message news:4b740963$1@forums-1-dub...
> This is discussed in the documentation - search for "limitations" keyword
> in the Index of the help file.
>
> The max rows / table is 4096 × 2^28.
>
> Performance of a database is more likely to be impacted by poor schema
> design, query implementation, and operating environment than the number of
> rows in a table.
>
> Cache size (the memory aspect that you are interested in a database
> environment) is dependent on the OS. The "limitation" reference covers
> this at a high level but also look at -cl, -ch, -c, and -cw engine option
> documentation for further details.
>
> The number of CPUs that the engine can support is limited by licensing.
> SQL Anywhere has no restriction of the actual 'processing' speed of the
> chip.
>
> POS wrote:
>> Hello,
>>
>> I am using PixelPoint POS v10 software. The database is SQL
>> Anywhere Network Server Version 10.0.1.3415. I want to know
>> the MAXIUM number of records any one table can have and also
>> at what point will the software experience slow response
>> times because of the number of records. Also, what is the
>> maximum amount of RAM the SQL engine will support? The
>> maximum amount of CPU power?


Alex Posted on 2010-02-16 03:42:39.0Z
Sender: 2549.4b7a13ab.1804289383@sybase.com
From: Alex
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: Maxium Number of Records
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b7a142f.2552.1681692777@sybase.com>
References: <4b737f6b.26c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Feb 2010 19:42:39 -0800
X-Trace: forums-1-dub 1266291759 10.22.241.41 (15 Feb 2010 19:42:39 -0800)
X-Original-Trace: 15 Feb 2010 19:42:39 -0800, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:326
Article PK: 18811

Anybody?

> Hello,
>
> I am using PixelPoint POS v10 software. The database is
> SQL Anywhere Network Server Version 10.0.1.3415. I want to
> know the MAXIUM number of records any one table can have
> and also at what point will the software experience slow
> response times because of the number of records. Also,
> what is the maximum amount of RAM the SQL engine will
> support? The maximum amount of CPU power?