search

archi-contribs / database-plugin

Database export/import plugin that store models in a central database repository
Other
81 stars 23 forks source link

Question : do you have any advise to size a database regarding Model size #166

Closed jmonsel closed 1 year ago

jmonsel commented 1 year ago

I'm looking to estimate db size before exporting models in it , so do you have any advise to size a database regarding Model size

Thank you

herve91 commented 1 year ago

How do you want me to guess ?

It all depends on your model, the number of elements, relationships, views, pictures ... you've got. It also depends on the database technology you plan to use. You may also considere if you export a screenshot of your views or not, and last but not least, as the plugin keeps all your model history, the number of updates you're doing ...

What you may do to estimate this regarding your own model, is te create a sqlite database on your local hard drive, export your model in it and you'll know.

Should you want a more precise estimate, the database model is provided in the "database structure" folder here in github and you may calculate the space required for each of you.

If you want an example, one of my models contains 9375 elements, 11509 relationships, and 266 views and the archimate file is 17MB. The same model in an sqlite database requires 32 MB.

herve91 commented 1 year ago

Does it answers your question ?

jmonsel commented 1 year ago

Yes, i'm fine with your answer