|
Home > Archive > SQL Anywhere database > May 2005 > What is the Maximum value for Database handled by Sybase ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What is the Maximum value for Database handled by Sybase ?
|
|
|
| Dear All,
I want to ask what the MAXIMUM value for database (Main.db)
handled by Sybase is.
Thank you.
-Sari-
| |
| Dmitri 2005-05-17, 7:23 am |
| Sari wrote:
> I want to ask what the MAXIMUM value for database (Main.db)
> handled by Sybase is.
Can't help wonder what did you meant by 'MAXIMUM value for database',
however the following chapter may be of interest to you:
--------------------------------------------------
ASA Database Administration Guide
Physical Limitations
--------------------------------------------------
Dmitri.
| |
| Greg Fenton 2005-05-17, 9:23 am |
| Sari wrote:
>
> I want to ask what the MAXIMUM value for database (Main.db)
> handled by Sybase is.
As Dmitri points out, the question asked is too vague. Do you mean what
is the maximum size of a .db file (see Dmitri's reply) or are you asking
about the maximum value for a particular datatype (and if so, which data
type)?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Breck Carter [TeamSybase] 2005-05-17, 1:23 pm |
| Really really REALLY BIG!
Breck
On 17 May 2005 02:25:27 -0700, Sari wrote:
>Dear All,
>
>I want to ask what the MAXIMUM value for database (Main.db)
>handled by Sybase is.
>Thank you.
>
>-Sari-
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
|
| Yes, I'm asking what is the MAXIMUM value size for Main.db.
I have a database consists of DBSpace1.db until DBSpace10.db
and also Main.db. And they're getting bigger everyday. The
size of Main.db is now approaching 2.5 GB. I'm afraid if it
reaches certain value, something bad may happen to the
database.
So, I'm wondering what is the MAXIMUM value for Main.db size
?
Thank you.
| |
| Dmitri 2005-05-19, 7:23 am |
| Sari wrote:
> So, I'm wondering what is the MAXIMUM value for Main.db size
As I've wrote in my previous message, the following chapter of the ASA
manual will answer your question:
--------------------------------------------------
ASA Database Administration Guide
Physical Limitations
--------------------------------------------------
In short: on modern file systems, you may consider it unlimited :).
Dmitri.
| |
| Breck Carter [TeamSybase] 2005-05-19, 7:23 am |
| 2.5G is small. Make sure the hard drive is defragmented, and the
database itself is reorganized occasionally, and you will be OK.
Breck
On 19 May 2005 03:09:13 -0700, Sari wrote:
>Yes, I'm asking what is the MAXIMUM value size for Main.db.
>I have a database consists of DBSpace1.db until DBSpace10.db
>and also Main.db. And they're getting bigger everyday. The
>size of Main.db is now approaching 2.5 GB. I'm afraid if it
>reaches certain value, something bad may happen to the
>database.
>So, I'm wondering what is the MAXIMUM value for Main.db size
>?
>Thank you.
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|