THanks for replying David. I am not using transactions and the indexes look ok. I finally just updated the core table, I need to find a routine to check for update conflicts incase two people tried to update at same time.


thanks
Nick patel