During your process loop -- when / where are the updates committed ? all at
the end ?
How may rows (approx) are you updating ?
FWIW:
I think you will probably find that it is NOT the SQL update that is your
bottleneck I am inclined to speculate that the performance issue is
related to the
List,
I have a client process that is causing some performance issues with my app. On
my current platform, the standard automated profiling tools are not available.
Consequently, I can't easily determine where the bottleneck is in the process.
I have an inkling that rewriting the client process