Re: Table lock with join.

[Michael Widenius]

Hi!

>>>>> "Jocelyn" == Jocelyn Fournier <joc@stripped> writes:

Jocelyn> Hi,
Jocelyn> So if I want overall high performance (i.e. no lock) I should stay away from
Jocelyn> join (or create alternate tables used only with join) ?

It depends on the problem at hand;  In many cases it's hard to avoid
joins.

If you have a setup where you need long reads mixed with writes, then
using InnoDB tables is a good solution.

Regards,
Monty