Click here to Skip to main content
15,891,136 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi i created a report and when i start running it for the first time it is fast it wqas fine for couple of days but later on when i run the same report it took like 15 min and later on the time went up , after that i created indexes on table and the genaration time went down to less than 2 min and later on the time went up , i tested it for same amount of data ,and i am the only one who run it , why is this happening is there any strong reason , i am the only one who access the server ,but still i dont get it , can any one help me out thanks
Posted

1 solution

I think you have problems with your server, it could be with the joins, cursors, open connections, or processor, ram, etc.
Try to run the query in SQL manually and check the "Execution Plan"
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900