8

I just purchased an unlimited shared hosting windows account on godaddy with 2 databases only to realise that they have a 200mb limit 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?

Qantas 94 Heavy
  • 15,750
  • 31
  • 68
  • 83
The_AlienCoder
  • 577
  • 6
  • 19

3 Answers3

4

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

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
0

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.

aviraldg
  • 9,531
  • 6
  • 41
  • 56
  • 1
    Modifying the generated Aspnet membership database will defeat the whole purpose of using it in the 1st place...i.e to save time...and in any case modifying the tables will crash the whole thing. – The_AlienCoder Oct 11 '09 at 11:19
0

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.

Community
  • 1
  • 1
Jawad
  • 19
  • 3