CODEWITHSUNDEEP
sap-ase
Guoping Zhang
Guoping Zhang

Reputation: 131

How many rows & how large table can Sybase ASE can handle

I am evaluating if we need to partition a table or not for ASE. We would need to do some typical DB opertions like CRUD, but no complex queries. Do you know normally, how large a table ASE can handle with decent performance? Like how many rows and how large the total size ?

Thanks,

Upvotes: 1

Views: 1044

Answers (1)

Adam Leszczyński
Adam Leszczyński

Reputation: 1161

The table size is only restricted by database size (docs).

The maximum database size is 64TB for a server with 16k page (docs).

And what about decent performance? It depends on the database schema and available RAM (amount of memory for cache) and what you define as decent performance.

Upvotes: 1

Related Questions