On Tuesday 05 December 2006 10:57, Bernd Helmle wrote:
> On Tue, 5 Dec 2006 10:18:21 +0000, David Goodenough
> <david.goodenough@btconnect.com> wrote:
>
> [...]
>
> > The first bits of the sync are done without locking the source tables,
> > and I do these until I find less than some suitable threshold of records
> > needing
> > to be updated. Then I lock the source tables and do the final sync.
> >
> > The statements issued to lock each table is:-
> > LOCK TABLE table IN EXCLUSIVE MODE; SELECT 1 FROM table;
>
> So why selecting '1' for each row after locking the relation before? I
> don't know HA-JDBC but this looks really useless. Remove the SELECT and use
> the LOCK TABLE command within the transaction which does the sync for you.
I will give it a try.
>
> Bernd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings