Hi,
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?
Thanks,
Phin