Consider as large DB

[former_SQLA_member1694872]

What can I consider as "large db" Honestly still could not figure out 😞 Database size? 1, 2, 3..10 GBytes???

[VolkerBarth]

FWIW, a long time ago there has been some kind of poll here:

What's the size of your biggest database?

According to that, databases in the 10 - 100 GB range are not uncommon with SQL Anywhere although I would certainly guess that the majority of databases (particularly those used as embedded databases and/or remote databases) are typically smaller.

[MarkCulp · Accepted solution]

I believe that you will find that the answer to this question is "It depends". It depends on the computer that is being used (e.g. a 1GB database running on a Raspberry PI could be considered large, but a 1GB database running on a 64 core x64 box with 1TB memory could be considered small). It also depends on the schema of the database and the workload of queries (inserts, updates, deletes, and selects).

[former_SQLA_member1694872 · Accepted solution]

@MarkCulp, then we can say: "It depends" is directly related to Hardware where the database is started?

[Breck_Carter]

500G with 1,000 active users, that's often regarded as "large" in the SQL Anywhere community.

Other measurements include statements like...

If it's hard to schedule a full backup then you have a large database.

If you are terrified of doing a restore then you have a large database.

If month-end reporting crushes online update performance then you have a large database.

If it takes days, weeks, months to make a simple schema change then you have a large database.

...where "large database" means "large for you" ( which is another way to say "it depends" 🙂

[MCMartin]

It is not uncommon for our customers to have databases in the size of ~300 GB using SQLA 12 and 16 and still growing. Some of them are running even on virtual servers.

And to add to Brecks list: It is large, if a sequential scan really hurts performance.