For 5K records:
01/09/2006 04:47:58 PM Started to run MEDICAID Name Search process
01/09/2006 04:54:02 PM Started to commit changes...
01/09/2006 04:54:57 PM Committed changes...
01/09/2006 04:54:57 PM Finished to run MEDICAID Name Search process
>Hi Naomi,
>the numbers you reported are probably too high for that to be the only fix -
>gut feeling across the atlantic <bg>. You have re-checked indices and triggers ?
>
>HTH
>
>thomas
>
>>
>>Nice talking to you as always. I'll switch to seek and replace while and hopefully the performance improves. I'm using the tables in shared mode and with buffering 5. The CommitChanges method is going to do begin transaction and tableupdates on all these tables.
If it's not broken, fix it until it is.
My Blog