does MySQL support transactions for concurrency issues
Posted: Tue Mar 11, 2003 9:41 pm
I have to write an online ticket allocation system for a small community-based show.
I'm just wondering if 2 people log on at almost the same time and try to purchase the same ticket, how would i deal with this ?
Is there a way to lock the database during the period or the first buying it so that the second has to wait ?
And if PostgreSQL is better for the job ... please let me know .... I have access to that also.
Any help would be great.
And example code would help alot also if anyone has any.
Cheers
I'm just wondering if 2 people log on at almost the same time and try to purchase the same ticket, how would i deal with this ?
Is there a way to lock the database during the period or the first buying it so that the second has to wait ?
And if PostgreSQL is better for the job ... please let me know .... I have access to that also.
Any help would be great.
And example code would help alot also if anyone has any.
Cheers