Hi,
So if I want overall high performance (i.e. no lock) I should stay away from
join (or create alternate tables used only with join) ?
Regards,
Jocelyn
----- Original Message -----
From: "Michael Widenius" <monty@stripped>
To: "Fournier Jocelyn [Presence-PC]" <joc@stripped>
Cc: "Internals@stripped" <internals@stripped>
Sent: Thursday, May 16, 2002 6:37 PM
Subject: Table lock with join.
>
> Hi!
>
> >>>>> "Fournier" == Fournier Jocelyn <[Presence-PC]"
<joc@stripped>> writes:
>
> Fournier> Hi,
> Fournier> Is there any way to avoid table lock with a join ?
>
> Sorry no; The locks are needed to ensure that no other thread is
> manipulating the table while we are reading from it.
>
> <cut>
>
> Regards,
> Monty
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail internals-thread3592@stripped
> To unsubscribe, e-mail <internals-unsubscribe@stripped>
>
>
>
>
