Estimating database size

[GregMc]

Hi,

I am running some tests around database size to try and determine what the potential usage might be for my app. To do this for the various collections in my app I am importing sample data of 10,000 rows and will base the projections on this. However after importing I see no change in the usage size number on the database summary page. I have waited over an hour since the import and still it shows no change in size. My questions are:

1. How long should I need to wait to see the "stored data" total number for the database to update?

2. Is there a better way to project database usage size. For instance one of the 10,000 row csv files I imported is 1.1MB. Can I assume the database consumption will be similar to this? Or is there some overhead with each database row?

   Thanks.

[Serhii Kulibaba]

Hello Greg,

1. This data updates once per day;
2. 1 GB of Storage for Standard plan. Please see https://appery.io/pricing

[GregMc]

Hi Sergiy,

1. Thanks for confirming that the data is only updated daily.

2. For my second question I am not asking about pricing. I can see how that works on the pricing page. I am asking how I can go about estimating my database storage needs. As an example lets say for my app I only have one collection and the collection has 1 million rows. The collection has columns that are String, String, Arrary, Array, Object, and date columns. If I can estimate the size of the data contained in each column is there a formula or estimation method I can use to determine how much storage this collection would take? I am just trying to understand how much storage my app might take in the database so I can see which pricing plan my usage would fit into.

[Serhii Kulibaba]

Greg,

There is not restrictions on column/row size. Only database size is limited by your plan.