I'll monitor the performance carefully during next week to see if this solution will solve the problem. Many thanks for your advices!
Today I re-built the indexes after the bulk insert via DTS packages. This solved the performance problems. But one question still remain, why does...
I've now made som additional tests and figured out that it's the function calls, at least 2 of them, inside this procedure that causes this...
Yes, I have turned on "auto create statistics" and "auto update statistics"? on the database but I don't run UPDATE STATISTICS or sp_updatestats...
This is how my VB code looks like, please remember that by executing FLUSHPROCINDB solves the performance problem temporarely! Public Function...
I can't understand why I don't get any performance problems when executing the stored procedure from the QA, only from the VB form and my web...
OK, I could try that. But why does FLUSHPROCINDB solve the problem temporarely but the next day the performance is really slow from the web...
I need help with a performance problem I have when running a stored procedure from a web application or a VB form. Sometimes the performance is...
Separate names with a comma.
