Hello, > So, should I start modifying the install scripts so that we use InnoDB > engine, or is a table-lock sufficient when myisam is used? Mysql will not > give an error if the engine does not support locking on individual rows. > So > the experience will be transparent for the end user, except for the > locking > of the whole table. >
A table lock might be OK, but probably far less efficient than row locks. There is also the possibility of there being some deadlocks in the presence code if entire table locks are used - I can't say whether this is likely or not as I haven't taken a critical look at the code with that in mind. Regards, Peter -- Peter Dunkley Technical Director Crocodile RCS Ltd _______________________________________________ sr-dev mailing list [email protected] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
