Geek Answers Handbook

How many users can use a 200 MB ASP.NET membership database?

I just purchased an unlimited shared hosting account with godaddy with 2 databases, only to realize that they have a 200 MB limit for SQL Server databases. My site uses an automatically created membership database in ASP.NET 2.0. The nature of my site (free ads) requires the storage of a significant number of users.

Since I use the standard ASP.NET Membership Database, which (hopefully) many of you have used before ... I was wondering how many users can store a 200 megabyte database?

+6
sql-server asp.net-membership
source share
3 answers

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 make a rough estimate, does that mean that with a 200 MB limit, you should be able to support 250,000 or more users - is that enough for you?

Mark

+3
source share

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

0
source share

You can check the link below and generate a report using the number of users (active) for the last 6 months.

Get the size of all tables in the database

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

0
source share

More articles:


All Articles