Re: MERGE tables and concurrent inserts

2004-03-24 Thread Chris Elsworth
On Wed, Mar 24, 2004 at 01:23:53PM +, Chris Elsworth wrote: > > I'm wondering if specifying LOW_PRIORITY disables concurrent inserts > explicitly, so I'll try removing that and see if anything improves, > but in the meantime, if anyone has any advice, please share :) Ignore that bit. Found th

MERGE tables and concurrent inserts

2004-03-24 Thread Chris Elsworth
Hello, Further to my MERGE table query the other day, I've now put it into action and it seems to be working fine. However I'm noticing that "INSERT LOW_PRIORITY" statements are blocking when there are SELECTs running. Does anyone know if concurrent inserts work with MERGE tables? Are there any c