Size of a CommCare database

Hi developers,

Just had a “bluesky” moment, daydreaming about some vaporware that would
locally cache an entire database… I was wondering what could be the database
size of a typical CommCare project, including forms, logs and so on ?

If you pick the biggest project so far, in the cloud or with local installs,
are we talking about MB, hundred of MB or GB ?

Many thanks,

··· -- Charles Flèche mHealth Advisor Télécoms Sans Frontières http://www.tsfi.org Première Urgence - Aide Médicale Internationale http://www.pu-ami.org

Hey Charles,

You mean the server database? Our biggest project (~600 users running for
multiple years) is around 20GB for the whole thing.

Cory

··· On Thu, Dec 18, 2014 at 7:12 AM, Charles Flèche wrote: > > Hi developers, > > Just had a "bluesky" moment, daydreaming about some vaporware that would > locally cache an entire database... I was wondering what could be the > database > size of a typical CommCare project, including forms, logs and so on ? > > If you pick the biggest project so far, in the cloud or with local > installs, > are we talking about MB, hundred of MB or GB ? > > Many thanks, > > -- > Charles Flèche > mHealth Advisor > Télécoms Sans Frontières http://www.tsfi.org > Première Urgence - Aide Médicale Internationale http://www.pu-ami.org > > -- > > --- > You received this message because you are subscribed to the Google Groups > "CommCare Developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to commcare-developers+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. >

Whoa, this is some serious data, I didn’t expect that much. Do these 20GB
include big files like pictures / video collected from the field users or are
they just database data ?

··· On Thursday 18 December 2014 11:21:36 Cory Zue wrote: > You mean the server database? Our biggest project (~600 users running for > multiple years) is around 20GB for the whole thing.


Charles Flèche
mHealth Advisor
Télécoms Sans Frontières http://www.tsfi.org
Première Urgence - Aide Médicale Internationale http://www.pu-ami.org

For this project it is mostly database data and not multimedia, however it
does include a lot of system data (device logs, sync histories, as well as
the complete history of all application builds etc.). My guess is that for
just forms and cases the number is quite a bit smaller, but probably still
in the GB.

At one point we made a sizing calculator for this type of thing. You can
copy it from here:


and play around.

Note that it has been a long time since we made this so the numbers are not
guaranteed to be accurate. Also the numbers were intentionally
conservative at the time it was made.

Cory

··· On Thu, Dec 18, 2014 at 11:25 AM, Charles Flèche wrote: > > On Thursday 18 December 2014 11:21:36 Cory Zue wrote: > > You mean the server database? Our biggest project (~600 users running for > > multiple years) is around 20GB for the whole thing. > > > Whoa, this is some serious data, I didn't expect that much. Do these 20GB > include big files like pictures / video collected from the field users or > are > they just database data ? > > > -- > Charles Flèche > mHealth Advisor > Télécoms Sans Frontières http://www.tsfi.org > Première Urgence - Aide Médicale Internationale http://www.pu-ami.org > > -- > > --- > You received this message because you are subscribed to the Google Groups > "CommCare Developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to commcare-developers+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. >