gosiggi


Hello,

i have some questions about the SQL Express Edition.

I read here, that the maximum of one Database is 4GB.
When i create a Webapplication, and i implements, the MembershipProvider, RoleProvider and the ProfilProvider, how many Users can i add to one Database

I think that i will have 60 - 100 Field Entrys for Profile of one Person.

Please can everybody help me with this Question
I need this Information, why i dont know that i make my Webapplication with SQL Express Editon, or with Mysql.

Thanks for your Answers

Best Regards
Siggi





Re: Some Questions about SQL Express Edition

Jens K. Suessmeyer


I don¡¯t think I got you yet, what is your actual question If 60-100 users can be used with theMembership provider model or within the database as database users What was your last question about

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---





Re: Some Questions about SQL Express Edition

gosiggi

What i mean ist, how many Users can i add in one Database from Sql Express Edition.

And one UserProfile have 60-100 Fields for Database Entrys from the ProfileProvider.

It goes , Firstname, Lastname, Street, usw........... that all are the 60 - 100 Fields for One User

And i dont now i can save with this 1000 or 4000 User in my Database when i use the SQL Express Edition.

I hope you understand know what i mean

Thanks and best Regards

Siggi







Re: Some Questions about SQL Express Edition

Jens K. Suessmeyer

Yes, now I got you. SQL Server Express can store as you already mentioned up to 4GB), If you don¡¯t how any binary data stored in the table, you can easily calculate the size that will be occupied for the amount of data, just add the size of the data type used together and you will have the summed rowsize. Multiply this with the amount of rows expected and you have the byte usage of your data. if you do not use any binary data you don¡¯t have to be a nitpicker and can calulate with 8060 bytes per rows which would mean for 4000 rows = ~ 32 MB maximum.

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---





Re: Some Questions about SQL Express Edition

gosiggi

Ich hoffe es erschlagt mich nun keiner weil ich hier in Deutsch schreibe.

So langsam steige ich dahinter, demnach kann ich doch nun eigentlich auch hingehen, und erst einmal komplett alle Profilfelder die ich benotige erstellen. Danach konnte ich alle Felder einmal ausfullen, wobei ich vorher die Datenbankgrose in Bytes festhalte, und nach dem ich alle Userfelder ausgefullt habe, nochmal die Grose der Datenbank kontrollieren.

Das musste doch eigentlich auch gehen oder sehe ich das nun so falsch

Vielen Dank fur die schnelle Hilfe zu diesen Thema

Mit freundlichen Grusen

Siegfried Schultz






Re: Some Questions about SQL Express Edition

Jens K. Suessmeyer

Noone will punch you writing in german :-D , but this is an international forum and the (inoffical) language is english.

But anyway, if you don¡¯t have any binary data, you can just count the number of rows times 8060 bytes. That should be not a matter of precise calculating, more a rule of thumb calculation.

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---





Re: Some Questions about SQL Express Edition

gosiggi

Hello,

Today i make some Tests and here is my resultat:
First i Create a new Database with this Options:

Start Database 3,00MB
Start Log: 1,00MB

Then i create all Database Tables with: aspnet_regsql.exe

Actuality Startup availible Space in DB is 1,34 MB

Then i Create a Profile Page with 2 Textboxes, 3 Textboxes Multiline, in Webconfig for Profile Propertys make this 5 Propertys as System.String:

Now the Results from my Test with 2 User in 1 Role:
TextBox1 and TextBox 2 = SingleMode

TextBox3 , TextBox4 and TextBox5 run in Multiline with 40 000 Chars in One Field

For 1 User it is ca. 120 000 Chars = 2 User x 120 000 Char = 240 000 Char in 2 Profile Database

Now i look at my Database Property how many Space i availibe and the Result is 0,32 MB.

So with this Options the Database need Space 0,5MB for One User and 120 000Chars in Profile

When i calculate it all rightly i become with this Options ca. 8 000User in one SQL Express Database:

Or is it not corectly

Now i have another Question:

Give it a Option that when the first Database is Full , that the MembershipProvider start to a new DataBase
Or must i overwrite the Membership, Profile and RoleProvider for that
When i must overwrite these Provider, give it an SQLCommand Statement for get the actuality Size in my ProgrammCode

And what is with the Performance, when i used SQL Express Edition on Windows 2003 Server with 1GB Ram, und 300 User are to the same Time on my Website

Again Sorry for my English

Thanks for all and best Regards

Siegfried Schultz






Re: Some Questions about SQL Express Edition

Arnie Rowland

In the language of SQL Server, you are not really talking about 'users', you are only trying to find out about storage for your data. In this case, your data has some business relationship to the users of your website. but it has little to do with SQL Server 'users'.

As you noted, a single SQL Server Express database is limited to 4 GB in size. You can have multiple databases on your server. If your application is designed properly and capable of working with multiple databases, you could elect to store data about your website 'visitors' in multiple databases. (Perhaps key information in one and optional information in another...)

In your last question, it appears that you are now referring to concurrent server 'users'. I would expect that if you had 300 truly concurrent users on a SQL Express server, you would most likely not be happy with the performance. But again, you have not clearly described the situation, and 300 truely concurrent SQL Server users would most likely be several thousand website users.






Re: Some Questions about SQL Express Edition

gosiggi

Hello,

ok thanks first for this informations.

I think i must write my last Question new

What is with the Server Performance when on my Webseite 300 User logged in and modified there profile at the same time

So also when my Webseite gets for 300 User at the same time data from my SQL Express Database.

I hope i write it so a litle bit better as my last question in the other post.

Best Regards

Siegfried Schultz






Re: Some Questions about SQL Express Edition

Arnie Rowland

If you have 300 users, all attempting to access the SQL Server Express database at the exact same moment in time, it may be slow.

But 'how slow' will most likely depend upon the speed of the server, the amount of memory, and the size of the queries.






Re: Some Questions about SQL Express Edition

Jens K. Suessmeyer

if you have that amount of workload and performace decreases, you should think about using another edition than SQL Server which would be able to scale up, using more processor an OS with more RAM, etc. The good thing is that you can start with SQL Server Express and upgrade anytime, as the database format is compatible with each other. You can just do a backup / restore or deattach / attach and the database will work at the other server.

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---