[sr-dev] db_mysql with Transaction support

[Peter Dunkley]

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