Creating Cube takes too long in ASP.NET

03-25-2009, 6:52 AM

Hi All,

We are using DynaCube in our ASP.NET application. When 2 or more user runs reports concurrently each user waits for others to create the cube file and preview in client explorer. We are using ASP.NET 2.0 and Windows 2003 Server Standard edition with Oracle x64 on Unix. I attached codes for review.

Re: Creating Cube takes too long in ASP.NET

03-27-2009, 4:01 AM

mustafacon,

Are you able to recognize what is taking so long? You can add some timing information to ASP.NET code, or greatly simplify the code (preferable) so we can determine exactly which method call is taking so long. Based on that we may be able to learn more about this issue. We can't test this here since we don't have database and most likely the delay is with the database queries. Also can you just save a static .cub file (with data) on the server and have two DynamiCube's load that static cub file from the server (using DataPath property). If the delay does not occur in that scenario then the problem is in querying the database or saving the cub file.

Also please note that DynamiCube is designed for ActiveX obviously. We have provided Data Dynamics Analysis (pure .NET control) which includes similar functionality to DynamiCube and much more. You can find more information here:
http://www.datadynamics.com/Products/DDA/default.aspx

Thank you,
Andrey T.

Re: Creating Cube takes too long in ASP.NET

07-14-2009, 2:05 AM
Hi
Report generation is taking so long. There is no problem with sql queries. The main problem is saving cub files. Users need to generate reports in more than one browsers at the same time by changing the filters. So I think lock occurs in web server. Do you have any suggestions?

Re: Creating Cube takes too long in ASP.NET

07-14-2009, 6:41 AM
oozsakarya,

The root of the problem might be in large .cub files. You can set some of your fields to DCPage orientation instead of DCRow
or DCColumn. Page field is similar to row field. But by setting field orientation to DCPage instead of DCRow we are producing cube in more compact way. When there are many row fields (or huge amount of data)
it would better to reassign some of them to page for better perception.

This KB article might be helpful:
INFO: Using the Page Dimension:
http://www.datadynamics.com/forums/282/ShowPost.aspx

Optimizing DynamiCube:
http://www.datadynamics.com/Help/DynamiCube3/OptimizingDynamiCube.html

Thank you,
Andrey T.