hi!
i got to the point where i have to perform some operations on 100.000 records [or more] and between the operation i dont want anyone to write/read from database.
1) how do i lock everything? is it possible to do it?
2) how long will it take mysql to perform some 100.000 queries [select, update, delete, insert]? can someone just give me approximate value? will that be 10 seconds, 10 minutes, 1 hour?
--- i also have to go with transactions. does mysql support them yet?
Matjaz
i got to the point where i have to perform some operations on 100.000 records [or more] and between the operation i dont want anyone to write/read from database.
1) how do i lock everything? is it possible to do it?
2) how long will it take mysql to perform some 100.000 queries [select, update, delete, insert]? can someone just give me approximate value? will that be 10 seconds, 10 minutes, 1 hour?
--- i also have to go with transactions. does mysql support them yet?
Matjaz