June 23, 2011 at 11:14 pm
Hi All,
I have designed a report in SSRS which is having very huge data performance is better with the datasets that i have created and also created the indexing for those columns which are used in the where conditions in the cube but my customer still needs more active performance
Would be a great help if any one response soon regarding this issue
Plssssssssssssss................
June 24, 2011 at 2:21 am
where are you doing the filtering for the where clauses? is it in the data set or in the report.?
how many datasets do you have?
June 24, 2011 at 2:27 am
Hi steveb,
I have one main single dataset for retrieving data into the table and also to the 10 charts,depending on the user selection charts will be displayed and others will be hidden thats all fine but having data in my db was 1.3 lakh records for that it is taking some 20 seconds and the time for 10,000 rec it is taking onlu 1/2 sec to display data but my customer needs for that 1.3 lakh data also less time for retrieving and Im using parameters in my where conditions in that main dataset itself
June 24, 2011 at 2:32 am
if you do not need absolutely the latest data then i would have a look at setting up cached datasets. you can preload the datsets at regular times and then execute the queries against them, of course the effectivness of this approach depends on the number of parameters you have and often they change.
http://msdn.microsoft.com/en-us/library/ee636149.aspx"> http://msdn.microsoft.com/en-us/library/ee636149.aspx
June 24, 2011 at 2:37 am
I think i cannot go for that cached datasets and I have 15 report parameters that are visible in my report and 3-4 as hidden
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply