Database size is 1 GB

We started to use erpnext 6 months ago.when we take database backup, zip file size is 325 MB and when extract 1GB.We created custom app for our company and using.is it normal to have the database size around 1 GB within 6 months?

1 Like

It depends on your usage and your data structures. It sounds like you use ERPNext heavily. In that case 1GB is not surprising at all. In 2017, 1GB for 6 months of data is almost nothing.

1 Like

Thank you @felix

@renjukumar

Am interested in knowing the volume of data/transaction that led to this in 6 months.

If it is possible I would like to know

Number of Items created
Number of employees/users
Daily Average number of transactions

Would also like to know the server specs you are using.

Thank you

1 Like

800 items
15 employees
200 transaction per day

aws ec2 2gb ram

1 Like

thank you

@renjukumar
I have same case in one ERPNext instance.
When I checked this, I found client is using email feature and in email he is attaching images.
So db size is increased a lot due to attachments.

6 Likes