Menu
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?
849
In SQL Server Management Studio, right click on Server, choose "Activity Monitor" from context menu -or- use keyboard shortcut Ctrl + Alt + A . Good option, but it requires more priviledges than DB_NAME(dbid) extraction from sys.
ASP.NET provides build in control to validate and store user credential. So, membership helps to manage user authentication and authorization in website. The membership provider is the glue between Login controls and membership database.
The App_Data folder is a special folder in ASP.NET that's used to store data files. For more information, see Connecting to a Database later in this article.
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
103
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
