Hi; I've a report with many dataitems which is very slow when running. I know that the question is very generic, and depends on each case, but, in general, which may be the main reason for which a report will slow down and how it can be solved?.
Thanks.
0
Comments
http://ssdynamics.co.in
2. Are you reading the same records many times? If yes copying them to a TEMP table once and then just reading that can be a good idea.
3. Download SQL Server Resource Kit from mibuso.com. Import objects called advancade client monitor or better client monitor or something like that. Run the standard client monitor (in Tools). Run the report. Run these objects. Wait. When the form opens, filter for elapsed time <>0. Copy the whole stuff to Excel. Set up a Pivot table that analyzes the sum of Elapsed Time by various dimensions f.e. Table Name or C/AL function or something like that, you will find out which operations are the slowest.
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community
Thanks everybody for reply. I've native 3.70 version. I'll test all your suggestions.
Thanks for help.