Performance question
Posted: Mon Jun 04, 2007 9:15 am
Hi All,
I'm running out of ideas. I'm having this complicated the job. The job processes a file row by row, (the order of the file content is also very important), depends on the value of incoming rows, it would go to 4 direction, each invovles a lookup and update or insert. The lookup table and update/insert table are the same one.
The problem I'm having is that when the job first starts, it runs more than 200 rows/second, then it keeps decreasing, until only 10 rows/second, which is really crawling. I don't know why the performace degrades so much and whether there is any way to prevent performance degrading.
Thanks a lot,
Carol
I'm running out of ideas. I'm having this complicated the job. The job processes a file row by row, (the order of the file content is also very important), depends on the value of incoming rows, it would go to 4 direction, each invovles a lookup and update or insert. The lookup table and update/insert table are the same one.
The problem I'm having is that when the job first starts, it runs more than 200 rows/second, then it keeps decreasing, until only 10 rows/second, which is really crawling. I don't know why the performace degrades so much and whether there is any way to prevent performance degrading.
Thanks a lot,
Carol