On Thursday 04 December 2003 09:41, Tim Ledgerwood wrote:
Hi,
> >What happens here, how many records are 'fetched', and how are you doing
> > it (SP's or client side)?
>
> Exactly ONE record is updated, and exactly ONE record is inserted. The
> record to be updated is selected by recordnumber, which is a primary key in
> the table. The selectivity is exactly ONE, so I am not sure that this is
> the problem.
OK, problably not. We did have a problem with memory on low spec machines a
few years ago with IB and IBX, but in that case there was quite a few records
involved.