on 2006 Mar 23 3:34 PM
I have a query that takes 20 seconds to load on our web portal. I've done everything imaginable to optimize performance. Finally I'm experimenting with pre-calculating the query. I've created the reporting agent setting, set the calculate parameter to 'HTML for Web Browser', added this to a schedule and successfully ran the schedule.
Now when I run the corresponding web template on the web it still seems to take the same 20 seconds. I would think all it has to load now is a static HTML page so it should take 1 or 2 seconds. How do I know if it's really loading the pre-calculated version or the normal one? I'm not sure anything is really happening. Maybe I missed something? Anybody have experience with this?
Thanks,
-Patrick
I think I figured it out. I had to add a parameter to my url that was UPDATE_MODE=STORED
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.