Okay here goes:
I have a login script that currently polls the database every time someone logs in. When you create an account as well, it polls through the database and verifies that someone with that name does not already exist. Not that there is anything wrong with doing that but originally this login script was going to be used as a way for admins, supervisors, teachers, parents, and students to login simultaneously. We have 12,000 students and a little over 1000 teachers in our program. Currently, I have a DateDiff command that also polls the database to see if they are logged in or not by taking the difference from the last login to the time Now(). Now the question:
If 2000 people log in at the same time or 2000 people are creating accounts, what will the reaction time for the server to react? I am thinking the threshold of the server will be affected, possibly shutting down. That’s 2000 polls to the database at the same time requesting either a login or create script. Right now my methods are on the beginner level. I am using a Request.Query string to handle the entire authentication for this to work. The Request.Query string basically polls the database to verify that user exists then continues onto the default.asp. I was wondering if there was anyway someone could walk me thru creating another method for logging in instead of using the Request object.
Can you use Sessions and if so could you provide a code example? I attached the sample parts of the login script anybody to look at.
Thank you for your help in advance, Phillip Ewing