Re: [GENERAL] Evaluating client processes vs stored procedures

2006-04-12 Thread codeWarrior
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

[GENERAL] Evaluating client processes vs stored procedures

2006-04-12 Thread Tim Hart
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