Book a Demo

Author Topic: Database Sizing  (Read 5243 times)

leonardo.santos

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Database Sizing
« on: July 11, 2014, 06:45:44 am »
Hello,

Is there any add-on or plug-in at EA that allows me to forecast the database size, once I have created the phisical model inside EA? I understand that once I have the tables defined with columns type and sizes, it should be able to informe the amount of rows for a period of time and then receive an extimation of the database size.

best regards,

Leonardo Santos
« Last Edit: July 11, 2014, 06:46:06 am by leonardo.santos »

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Database Sizing
« Reply #1 on: July 11, 2014, 06:50:03 am »
AFAIK there is nothing out of the box for that. There's an add-in called DBMode from Sparx Japan where I don't know its functionality.

Anyhow I guess you could write up your own script to do that calculation. Should probably not be too difficult.

q.

martin1

  • EA User
  • **
  • Posts: 57
  • Karma: +0/-0
    • View Profile
Re: Database Sizing
« Reply #2 on: July 14, 2014, 08:03:52 pm »
If I understand the question correctly, you could use another database backend together with EA, like MySQL, and use its tools to predict the resulting amounts of data.

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Database Sizing
« Reply #3 on: July 14, 2014, 08:23:14 pm »
Hi,

in my experiences 100MB database size is a good starting point.

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)