| |
DynamiCube Support
Started by mustafacon at 03-25-2009 6:52 AM. Topic has 3 replies.
  
|
|
Sort Posts:
|
|
|
|
 03-27-2009, 4:01 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: Creating Cube takes too long in ASP.NET
|
|
|
|
|
|
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.
|
|
|
|
|
Report
|
|
|
|
|
07-14-2009, 2:05 AM
|
oozsakarya
Joined on 07-14-2009
Posts 3
|
Re: Creating Cube takes too long in ASP.NET
|
|
|
|
|
|
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?
|
|
|
|
|
Report
|
|
|
|
|
07-14-2009, 6:41 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: Creating Cube takes too long in ASP.NET
|
|
|
|
|
|
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.
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » DynamiCube Supp... » Creating Cube takes too long in ASP.NET
|
|
|
|
|