locked
SSRS with multiples datasets which query same table RRS feed

  • Question

  • User-1350042179 posted

    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?

    Saturday, September 8, 2018 7:50 PM

Answers

  • User-1350042179 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, September 11, 2018 3:56 AM

All replies

  • User283571144 posted

    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

    Monday, September 10, 2018 5:41 AM
  • User-1350042179 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, September 11, 2018 3:56 AM