Alan

>I'll try this, but I think it's the query that actually looks for the key in
>the first place, not the INSERT that is slow...I'll do some testing to see.

That's why I thought try one without the query just relying on error handling. Still its nice to know you've found the problem and have solved it.

Roy Lambert

Alan,

<< This was the kind of dumb thing I was afraid I would find. After leaving
it for a few hours and coming back to it, I saw that the way I was doing
something caused the engine to have to connect each time through an
interation instead of once. No wonder it was slow. >>

Yep, that will do it.

Thanks for letting us know what you found out.

--
Tim Young
Elevate Software
www.elevatesoft.com