I found out what the problem was with this. It is to do with the MySQL indexes and how it maintains their cardinality.

MySQL defaults to taking 8...

Hi Mike,

Same building, same server room - possibly not regarded as on the same network (my networking skills aren't exactly sys admin level);

The source database is a linux server with...

Hi Mike,

Thanks for the info, that's great. I think i'll have a bit of a google about that subject and see what I can change. Also, due to...

Excellent, thanks both for your replies. I'll give them a try shortly, but it looks like they'll work perfectly.

Also, apologies, I forgot to paste the root node into the...