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
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
---
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
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
---
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
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.
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
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.