Viewing 8 posts - 1 through 8 (of 8 total)
Hi,
thanks to all for their help and tips.
You are right, the RS statement still had the index hint, but it did not help. The result is the same without the...
July 9, 2008 at 11:44 pm
Hi,
Yes, you've got it! I am impressed, the report is now finished in 7 seconds! Collecting the data now only takes 0,3s in reporting services, 10 times faster than it...
July 8, 2008 at 10:01 am
Hi,
here are the results. First picture (ManagementStudio.jpg) shows statement and result for direct execution in the management studio. The second picture shows the result for the reporting services. You can...
July 8, 2008 at 8:46 am
Thanks again for all the good ideas and hints.
I took a look at the statements with the profiler, but I can see no difference between the statements. I also took...
July 8, 2008 at 7:05 am
Thanks for the good idea, but no, I am using the direct SQL Server connection (OLEDB). I also played around with the other connection types, but it did not change...
July 8, 2008 at 3:46 am
Hi,
you are right, but in my opinion it does not explain why it is fast in the Management Studio (3 seconds) and slow in the reporting services (60 seconds). The...
July 8, 2008 at 3:26 am
Thanks for your answer GilaMonster!
I am afraid I can tell you no details, but I think this isn't necessary. The index was built just before the tests on Saturday and...
July 7, 2008 at 4:39 am
Hi again,
now I am confused a little bit more! I did the tests on Saturday and wanted to repeat them and verify the results today. Today I can remove the...
July 7, 2008 at 2:38 am
Viewing 8 posts - 1 through 8 (of 8 total)