Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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

asked 01 Dec '15, 15:34

Walmir%20Taques's gravatar image

Walmir Taques
accept rate: 12%

edited 01 Dec '15, 15:34

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.

(02 Dec '15, 01:18) Volker Barth

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).

permanent link

answered 01 Dec '15, 15:38

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

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

(01 Dec '15, 15:56) Walmir Taques

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" :)

permanent link

answered 01 Dec '15, 16:06

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

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.

permanent link

answered 04 Dec '15, 08:33

Martin's gravatar image

accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 01 Dec '15, 15:34

question was seen: 1,937 times

last updated: 04 Dec '15, 08:33