6 Replies Latest reply: Mar 7, 2017 12:55 PM by Bill Markham

Ideas on Reloading Same app in two streams

Guruprem Saginadham Mar 7, 2017 9:39 AM

Hello,

I have a Sales App, which I have published in Finance and Sales Streams. Now when it comes to reloading currently, I am reloading two published apps twice. Is there any way that I can reduce the loading time of second apps? Since the data is loaded already in first app. But fundamentally, I know that Qlik treats each app as separate. Give me suggestions to optimize the loading time.

Re: Ideas on Reloading Same app in two streams

Bill Markham Mar 7, 2017 10:09 AM (in response to Guruprem Saginadham )

Maybe binary load the second app from the first.
Like Show 0 Likes (0)

Actions
Re: Ideas on Reloading Same app in two streams

Shubham Singh Mar 7, 2017 11:19 AM (in response to Guruprem Saginadham )

It shoud not matter if your reloading same app twice. You should use a proper 3 layer architechture so that your published UI app should only take a few seconds to maximum two minutes for reloading. To do that move all your calculations to a transform layer and UI should only contain LOAD * statements.
Like Show 0 Likes (0)

Actions
- Re: Ideas on Reloading Same app in two streams
  
  Bill Markham Mar 7, 2017 11:38 AM (in response to Shubham Singh )
  
  ..maybe not always a Load *, best to only load the fields from QVD that are needed. This will de-optimise the QVD load.
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Ideas on Reloading Same app in two streams
    
    Shubham Singh Mar 7, 2017 12:02 PM (in response to Bill Markham )
    
    Why store those fields in QVD if you don't need them in UI. Drop those unnecessary fields before storing QVD. This will reduce size of QVD.
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: Ideas on Reloading Same app in two streams
      
      Bill Markham Mar 7, 2017 12:55 PM (in response to Shubham Singh )
      
      QVD's can be used as data sources for multiple dashboard apps and some app[s] may need different fields from the QVD's than other app[s] need.
      
      But yup, if no apps need certain fields from the QVD - then as you suggest best not store in the QVD fields that nothing uses.
      
      Like Show 0 Likes (0)
      
      Actions
Re: Ideas on Reloading Same app in two streams

Guruprem Saginadham Mar 7, 2017 11:45 AM (in response to Guruprem Saginadham )

Thanks. I do follow scripting best practices. Now I found that question it self in correct because when there are two apps they will be loaded twice all we can do is load only from QVDs. Thanks let me close this thread.
Like Show 0 Likes (0)

Actions

Go to original post