Instance performance with CE10

[Duckie66]

Hi,

I have an instance performance problem that I'm hoping someone can help with. I'm using CE10 with RAS, database is MySQL 4.1.

I have scheduled about 30-40 reports to run daily overnight. This is done by 3 Report Job Servers and instances are ready in the morning. The smaller instances (<50000 records) work fairly well but the bigger ones take 5+ minutes to bring up the first page of instance. That is definitely too much.

I have same kind of grouping in all of the reports:
1st level: Week no
2nd: Date
3rd: Datasource

I'm using RAS because it'd be nice to get the whole instance at once (= browsing the data is fairly fast after there is something on the screen). Getting report is done by ASP and the instance is shown with the interactive viewer.

Is there a way to 'pre-cache' instances in the morning before any user gets in? Or are there any significant properties that can be fixed? Or... is just the fact.. that Enterprise is a turtle with large amounts of data?

Thanks for advance,

Duckie

 

[synapsevampire]

A report with > 50K rows is generally a bad idea.

You might consider on demand subreports for this level of detail data, and when the user wants the details, they can query it.

-K

 

[Duckie66]

Synaps, thank you for your answer.

My data is based on hours so record count will be large - I have to just accept that. But now I'm going to continue with on-demand subreport. One q conserning that:

Is it possible to use drill down menu with subreports? For example, in this case, would it be possible to group by week number and then call subreport directly from drill down? So there wouldn't be the need to press a link from week-page. The weeknumber is parameter to subreport.

Duckie

 

[synapsevampire]

Not sure what a link from week page means, but an on-demand subreport requires that the user click on it.

Just because your data is based on hours doesn't mean that you need every row. If Mgmt says that they want to view every hour of every day's data, look for a job with better Mgmt

Creating a summary report makes more sense, so you wouldn't have the details in there, just the summaries. If they really want to drill into the data, give them an on demand subreport to do so for the required granularity.

Unfortunately Crystal doesn't provide drill down as elegantly as some of it's competitors, but overall Crystal provides much more functionality.

-k