Hi,
I am facing some performance problems.
Pre-Infos:
QVW Size : 35MB
Sheet(tab) Number : 70
Object Number : about 5000(text, chart included)
Quite alot objects in a single QVW document though.
So here is my question.
1. Reducing refreshing time
When a user approach Access Point and click the document, it takes time for 5~6 seconds. And because of hourly data, it should be reloaded every hour. So guess what happens? QVW in Web pauses for 5~6 seconds every hour.
However when it comes to Data Size, which is 35MB, it seems to be small to take that much time. So I guess this is because of the number of objects. But here is the problem. My customer wants to put all these objects(includes text objects) in a single QVW. So dividing qvw cannot be an answer. Then what can be my choice to improve this time to 1~2 seconds?
P.S I've tried
preload, not helping.
hide sheets that I do not use, also not helping.
put calculation expressions into script as much as I can, still not enough.
2. Partial Load without Publisher
As I said above, I have hourly data. And it is real small part of my data model, but it has to be reflected to my data model so the whole data model should be reloaded. For now it is small amount, so everybody is fines with this. But in future, it cannot be.
Although We are not supposed to use Publisher, is there any way to use partial load for this data to reload itself only so that the whole data doesn't need to be reloaded.
Thanks!
