Optimization Tips and recommendations for multiple logins at same time in an ASP.Net Website

Hi, Nauna,

There is not just a single line solution we can suggest you in few words, like a newtons law, But some thing I can suggest you do that..,

1. The first concern is DataBase. DataBase should be well structured, Relational and should be normalized.
2. Always use stored Procedures, dont use SqlDataSource, Or Inline queries,
3. Select Requried data only, try to avoid "select * " query.
4. If you are using CURSOR, dont use unnecessarily.
5. Set Indexes on required columns.

Asp.Net

1. Use lighter control, I mean a work which can be done by html control, dont use Generic, if it cant and can done by generic dont use Server control, at least avoid to use it.., Further more A work can be done by Repeater dont use GridView.
2. If you are using GridView to represent data, then never use inbuilt Paging, but the Custom Paging.
3. Dont always use full postback, If possible use AJAX, like jQuery AJAX Or UpdatePanel whichever is suitable

C#

1. Instead of using for i loop, if possible use foreach loop.
2. Use !IsPostBack to set all the controls which supports ViewState.

Thanks and Regards,

Rk_Hirpara

1. 200 Users for a website hosted on a sound server with proper resources and RAM, will not cause any problem

2. As initially I told you that must close the existing connections,

Simple example would be Open connection very late, Close Connection early. Example

con.Open();
cmd.ExecuteNonQuery();
con.Close();

Thus the above makes your connection available easily.

For time being this will make your website work and if you need to enhance further you can look through the steps from Mr. Hirapara