 |
| ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
October 17th, 2006, 09:10 AM
|
|
Authorized User
|
|
Join Date: Jun 2006
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Concurrency issues
Hi all,
Interesting question, I work on academic software and has a question on concurrency issue. Students get registered in class through our online registration. If there is only one seat left in the class and two or more students try to register online at the same time then how would i deal with the concurrency issue. my options put them on waiting list in the database even then if 2 different students are on waiting list at the same time which student should get enrolled first to the course. other options are pooling(or threading) and other option is session objects. Please let me know the best possible solution in this case. I don't need any coding here but need to know how to find out way to do this.
Thanks,
Cindy Priya.
|
October 17th, 2006, 10:21 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
|
|
hi there..
well.. it's depend on how are you register the students... there is a moment when you assing the student a sit, in that moment (unless you have a multiprosesor unit) you will have one and only one thread running. that's the only student that get the sit.
If you have another model (something like: you have a sit, fill the data, assing the sit) then you will have probably a problem if the user didn't finish his registration.
we can discuss this all year ;) what model are you using???
HTH
Gonzalo
|
October 18th, 2006, 11:16 AM
|
|
Authorized User
|
|
Join Date: Jun 2006
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hello Gonzalo,
Thanks for looking into this Gonzalo, I'm not sure what you mean by "which model i'm using?" I don't have to fill in anything. Once user is in registration screen all they do is, select the available course and hit Register button in order to get enrolled into a course. Do you think i can use Optimistic or Pessmestic lock on the database in this regard, Let me know. Also I'm not sure about the models so let me know what kind of models are available.
Thanks
CindyPriya.
|
October 18th, 2006, 11:42 AM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
|
|
hi there...
by model i refer what type of architecture you will use in your aplication...
the way you plan to do this, looks like optimistic look will do the trick.. there could be a case that a student hit the submit button and receive and error that he cannot enroll in a class due to a submit at the same time in another site, so you will have to check for that error. Use transaction to avoid problems.
HTH
Gonzalo
|
|
Similar Threads
