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.

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

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.

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