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

Resolved nested datawindow optimization

  1. How-to
0
Votes
Undo
  1. Neil Prichard
    Neil Prichard
  2. InfoMaker
  3. Thursday, 18 March 2021 22:10 PM UTC

Hi all, 

i am currently creating a calendar style report that splits the AM and PM with two datawindows, however i'm finding it painfully slow to run for even a week, upto 1 minute for just a week and it only generates 6 pages. Does anyone have any advice on optimizing using nested datawindows for reports?  When ran separately they do not take long to run at all, but when they are nested it seems to cause this issue. 

thanks , 

Neil 

Where is the InfoMaker Stylelib?
Cannot Save IM Files as PDF
Responses (2)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 19 March 2021 16:24 PM UTC
  2. InfoMaker
  3. # 1

InfoMaker does not provide the option Chris mentioned; he was speaking of PowerBuilder code.

I am assuming that you have looked at the SQL in the nested reports and optimized it as best you can.

In your case the best thing to do to speed up the processing would be to either break this into two reports, or to add a parameter to this report such that the result set returns only the AM or PM values.


Olan

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 18 March 2021 23:48 PM UTC
  2. InfoMaker
  3. # 2

Hi Neil;

   When you are creating / running the Nested DWO ... are you using SetReDraw(FALSE) during this processing. Only setting SetReDraw(TRUE) when completed (or RetrievEnd event)?

Regards .... Chris

Comment
Neil Prichard
  1. Neil Prichard
  2. Friday, 19 March 2021 15:14 PM UTC
Hi Chris,

thanks for the reply, is that something i can set from within Infomaker? if so where can I find that option?

Thanks

Neil
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 19 March 2021 19:21 PM UTC
Hi Neil;

My apologies, I missed the fact that you were talking about IM. Olan is correct ... you would need to be using IM's big Brother/Sister PB (not sure of the gender - LOL).

Regards ... Chris
  1. Helpful
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.