How many users can a 200mb ASP.NET membership database hold?

I just purchased an unlimited shared hosting windows account on godaddy with 2 databases only to realise that they have a 200mb limi开发者_StackOverflow社区t on SQL Server databases. My website uses the automatically generated ASP.NET 2.0 membership database. The nature of my website (free classifieds) requires the storage of a significant number of users.

Since I'm using the standard ASP.NET membership database that (hopefully) many of you have used before... I was wondering just how many users a 200 mb database could hold?

Depends on your other information in the ASP.NET membership table (applications, roles etc.) - but I did a quick experiment to get a rough idea:

Users      Disk space used on disk (MB)
------      ----------------------------
 5'000                5.5 MB
10'000                8.9 MB
25'000               18.1 MB
50'000               33.8 MB

If you do a rough estimate, this means, with 200 MB limit you should be able to support 250'000 users or more - enough for you?

Marc

It depends on what you need to store. Obviously, if you have many fields, then it will be fewer than a table with less fields.

You may check the below link and generate some report using number of users (Active) in last 6 months.

Get size of all tables in database

The above article will help you get actual size of each table and you may take average to at least make some projection.