BusinessObjects Board

Effect of increasing webi instances

other Xcelsius - Crystal Dashboard Design
#1

Hi,

Would like to know what is the effect of increasing webi instances for Dashboard performance.
Currently i have

  • 5 instances
  • 15 web services
  • 40 components
  • Data less than 512 after filters & conditions
  • do not have complex functions(like sumif’s, vlookup, index, match)
  • Version 4.0 sp7

Dashboard load time is 40 sec.
If i increase the webi instances to 10…would it help? Other things which i may have overlooked

Thanks

kraf (BOB member since 2013-06-25)

#2

Hi,

Do you mean increase the number of webi instances to use them instead of web services (eg. QaaWS)?

Fetching data from the latest instance is always faster than doing an on-demand refresh so if this is the case the performance for your dashboard could increase drastically.

If all your data sources are set to refresh on open it would be good to check whcih of your 20 sources is taking the most time to open as it could be affecting the overall performance of your dashboard.

iguanasterix :iceland: (BOB member since 2008-02-18)

#3

Yes increase the webi instances to load the latest instance. Currently its loading from the latest instance.

10 connections are “refresh before components” other 5 are after.

kraf (BOB member since 2013-06-25)

#4

what is the load time when all connections are turned off ?
where is the SWF hosted?

40 seconds is way too long.

Cairmor :us: (BOB member since 2008-06-05)

#5

Without connections but webi instances are still active.
After loggin it took 20 sec to display 11 components with data(drop downs’s are not getting any data)

Currently i’m just previewing from “Preview”…but same time from Lauch Pad

kraf (BOB member since 2013-06-25)

#6

Also the webi report with 14 webi blcks(web services) is taking 2min to load.
Also i have a ranking in 4 webi blcks…could this be eating up time.

kraf (BOB member since 2013-06-25)

#7

Did you already configure your BIWS connection (use last instance) to actually use the last instance of the Webi ?

Aside from that topic, 20 seconds to load 11 static components ? There is something else going on…perhaps some local scan when you interact with SWF files. Your file might be bloated. Does the filesize seem appropriate ?

Cairmor :us: (BOB member since 2008-06-05)

#8

Yes, it is already using the last instance.
I know we have diverted a little bit from the question, just to go back “would having 10 webi instances would make a diff than having 5”.

file size is 156kb. how can i figure out wts going on.

kraf (BOB member since 2013-06-25)

#9

Have 100 instances is no different than 2 instances. They are saved file objects.

Please test the 156kb SWF file (unconnected to live data) on at least two other systems. Does the speed improve ?

Cairmor :us: (BOB member since 2008-06-05)

#10

Thanks, but i’m really confused…if they are stored as files…then when a dshbrd is run, it should hit all the instances of that webi report.

If the above statement is correct then having more instances should retrieve the data faster.

Also should i segreate the webi into 2/3 reports…could all the 14 blks on one webi report is the issue. Just thinking…

kraf (BOB member since 2013-06-25)