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.

Large Database file.

2 posts in General Discussion Last posting was on 2009-06-01 21:41:10.0Z
Aron Posted on 2009-06-01 20:49:55.0Z
Sender: 7092.4a2435e7.1804289383@sybase.com
From: Aron
Newsgroups: ianywhere.public.general
Subject: Large Database file.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a243ef3.71b1.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Jun 2009 13:49:55 -0700
X-Trace: forums-1-dub 1243889395 10.22.241.41 (1 Jun 2009 13:49:55 -0700)
X-Original-Trace: 1 Jun 2009 13:49:55 -0700, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7587
Article PK: 5987

Hi, we are using Sybase SQL anywhere 8.0. Our database file
is almost 200 megabytes. As far as size is that normal? Up
to how many megabytes of a database can sql anywhere handle?

Thanks
Aron


Josh Savill [Sybase] Posted on 2009-06-01 21:41:10.0Z
From: "Josh Savill [Sybase]" <no_spam_jsavill_no_spam@sybase.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Large Database file.
References: <4a243ef3.71b1.1681692777@sybase.com>
In-Reply-To: <4a243ef3.71b1.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a244af6$1@forums-1-dub>
Date: 1 Jun 2009 14:41:10 -0700
X-Trace: forums-1-dub 1243892470 10.22.241.152 (1 Jun 2009 14:41:10 -0700)
X-Original-Trace: 1 Jun 2009 14:41:10 -0700, vip152.sybase.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7588
Article PK: 5986

Aron,

I would consider a 200 MB database small. I do not have the specifics from the SQL Anywhere 8
documentation, but I believe it is the same as SQL Anywhere 9.

For NTFS, maximum file size:

256 GB for 1 KB page size
512 GB for 2 KB page size
1 TB for 4 KB page size
2 TB for 8 KB page size

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbdaen9/00000789.htm

--
Joshua Savill
Sybase Inc. - Product Manager

Aron wrote:
> Hi, we are using Sybase SQL anywhere 8.0. Our database file
> is almost 200 megabytes. As far as size is that normal? Up
> to how many megabytes of a database can sql anywhere handle?
>
> Thanks
> Aron