Performance optimization - while creating Excel reports
Can anyone suggest me the proper approach for performance optimization while generating around 600 excel reports programatically.
I am facing issues different issues like:
-> Un ending loop.
-> Code crash after generationg aroung 25 to 30 reports at a time.
I am using Excel COM object to create excel report.
thanx in advance for suggestions.
Re: Performance optimization - while creating Excel reports
A never ending loop is not a performance issue; it's a bug in your program.
A crash is, again, not a performance issue; it's a bug in your program.
These aren't random occurrences. Spend some time in the debugger, come back here, and then tell us
1. What exception is being thrown?
2. Under what circumstances do these problems occur?
3. What have you already tried?
Next step; show us your code so we don't have to guess at what the problem is.