We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
SSRS with multiples datasets which query same table[Answered]
2 replies
Last post Sep 11, 2018 03:56 AM by neoaguil17
Last post Sep 11, 2018 03:56 AM by neoaguil17
Member
177 Points
629 Posts
SSRS with multiples datasets which query same table
Sep 08, 2018 07:50 PM|neoaguil17|LINK
Hi
I have a SSRS which 6 datasets which read the same table and the report is very slow.
Should I check the option: Use Single Transaction?
Star
9831 Points
3120 Posts
Re: SSRS with multiples datasets which query same table
Sep 10, 2018 05:41 AM|Brando ZWZ|LINK
Hi neoaguil17,
As far as I know, this option means SSRS opens a single connection, executes the datasets/queries that use the data source, and closes the connection.
You could use it to reduce the amount of open connections to the database.
If you have it checked, then only one connection will be open to the database and all the datasets will return the data and the connection will be closed.
This can be used to reduce network traffic and potentially increase performance.
Best Regards,
Brando
Member
177 Points
629 Posts
Re: SSRS with multiples datasets which query same table
Sep 11, 2018 03:56 AM|neoaguil17|LINK
Hi
I verified that when I use transactions is better since without transactions I open many connections but there is blocking to the same table.
I read and followed this article: https://vsstack.blogspot.com/2014/01/ssrs-use-single-transaction-when.html?m=1
Without transactions the datasets run in parallel but there is blocking to the same table.
With transactions the execution is one by one and faster