471,046 Members | 835 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,046 software developers and data experts.

HELP: OLAP data cube in web browser loads slow or errors!


I am using the OLAP data cube in a web browser (using the code from
the SQL 2000 toolkit). The OLAP services is on database server and the
web interface is on the web server. If we do simple queries on the
cube, it works fine. When we do complex queries the cube in the web
browser loads very slow or errors. Also, I noticed that when it is
building the output for the cube (the display) that most of the
processing is taking place on the web server and not the database
server. Our database server is a much faster machine with 8 processors
(our web server has only one processor).

Besides moving the web interface of the data cube to the faster
database server or adding more processors to the web server, is there
anything that I can do to improve the performance of the cube, so that
complex results load quicker and do not error out?


Jul 20 '05 #1
0 2969

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Philip Stoev | last post: by
1 post views Thread by Devin McMahon | last post: by
3 posts views Thread by Pradeep | last post: by
3 posts views Thread by Naeem | last post: by
1 post views Thread by =?Utf-8?B?TWFyaw==?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.