View Full Version : Mondrian Performance with large DB

11-20-2003, 11:23 AM
I was wondering what kind of response you people are getting when accessing large databases with mondrian. I have star schema with the fact table of approximately 3GB (8 million rows) and 4 reference tables in MSSQL Server and I am gettng response of about 3 to 5 mins everytime a query is executed for the first time. The database table has been optimised but the response time seems poor.