Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Replacing Rows to Disk unsupported feature

  1. How-to
0
Votes
Undo
  1. Preetish Agarkhed
    Preetish Agarkhed
  2. PowerServer
  3. Wednesday, 24 January 2024 12:45 PM UTC

Hi All,

I have been trying to replace unsupported feature Rows to Disk for the reports in our code base. Each of these reports have numerous nested reports, with each report having a SP as a datasource.

What I could think of is to check the number of rows in retrieverow() event and stop the retrieval, if rows retrieved matches a huge number. But this will cause performance issues.

Any suggestions?

Thanks in advance.

IIS Settings Not Persisting when a build and deplo...
webapi log file
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 24 January 2024 20:16 PM UTC
  2. PowerServer
  3. # 1

Hi Preetish;

  What about this alternative (just a thought) ...

  1. The PS PB App calls a SP to produce the report.
  2. The SP marks the report "in progress" in a DB "control table"
  3. The SP then then calls a PB App EXE located on the DBMS server
  4. The PB App performs the report as it does today.
  5. The PB App then saves the report as either (for example) a PSR or PDF data stream back into the DB within a Blob column
  6. The PB App then marks the Report as "Ready" in the DB "control table"
  7. The PS App "polls" the DB "control table" checking for a "Ready" report status
  8. When the report is "ready", the PS App then retrieves & displays the finished report for the App user

Food for thought.  HTH
Regards .. Chris

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.