[weilies]

hi, i hv a situation here,

let say 1 visitor need to add one line of record into the script before it proceed to the next line of code, but wht if 100 visitor access con-currently, then wht will happen?

question
1. will the other visitor going to wait for the one to write to the text/csv file before they can proceed?
2. will some of the records going to mis-insert into the file?
3. What if i want all of their record 100 lines to be inserted nicely, wht is the better approch?


Thanks

[duesi]

Your problem is the reason why there are databases. If you write to a file, this causes a lock, which means that nobody else can write to the file until you are done. In toher words: there can be a lot of people waiting.
A Database manages exactly this situation: it manages the concurrency efficiently (but Mysql is not the best of examples for this kind of stuff, if you need a real DB. look at postgresql or oracle).