Database Size Estimate

[oogway]

Can anyone help me estimate the size (in disc space) of a MySQL database that had 3.2 million leads in SugarCRM?

Many Thanks,
Daniel

[thinkwelldesigns]

Here is a link that should work for you. http://forums.mysql.com/read.php?108...578#msg-201578

[oogway]

Here is a link that should work for you. http://forums.mysql.com/read.php?108...578#msg-201578

Thanks, but my database is empty. I'm looking for someone to say something like this: "We have 1.2 million leads and our database is 3GB", or whatever they have, even 100,000 records could be a starting place for an estimate.

I just need a quick figure to give management a ballpark figure purely for estimation purposes.

Daniel

[sugarcane]

Depends on a lot of factors. As an example I have a leads table that has ~2400 records and is 800k big. But if you are going to have custom fields that could make it an extra 400k or less or more depending on how many custom fields you have.

We have done custom setups with 15 million records in one table, but it required some tuning and adjustments to optimize the table.