>Hi,
>My primary is a composite key , combine by appid + grpid +itemcode.
>And the key fields i set in update criteria is appid, grpid and itemcode.
>
>The application is in the same machine with the database. Does 10secs for 2,000 records is acceptable?? SOmtime it can take until 20-30 secs... :( AGain, What happened if other client machine do the same thing across network?? Will it take longer time?? Then sure my client will complaint about it.. :(
>
>I used to try delete 2000 recrods for table, but it just take about 1 seconds.. how come the time taken by view is too different? Any workaround?
>
>Thank you
I don't know - perhaps my FAQ #8109, on Rushmore Optimization, can give you some ideas.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
