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.