High Performance

becomex_jle · Post by **becomex_jle** » Fri Nov 18, 2011 10:38 am

Hi,

What better way to build a report with high performance (based on a million rows)?
best practices, types, components, datasource, ...

* Using StiWebViewerSL

Post by **HighAley** » Mon Nov 21, 2011 3:38 am

Hello.

becomex_jle wrote:What better way to build a report with high performance (based on a million rows)?
best practices, types, components, datasource, ...

* Using StiWebViewerSL

We can give you some advises:
- write SQL-query to filter only needed data before getting it in the report generator.
- select only those fields that you use in the report
- less data conversion as possible especially string to number
- create a simple reports with minimum or without grouping, containers and sub-bands

More detailed recommendations can be given after analysing your report and data.

Thank you.

becomex_jle · Post by **becomex_jle** » Mon Nov 21, 2011 10:45 am

Aleksey wrote:Hello.
becomex_jle wrote:What better way to build a report with high performance (based on a million rows)?
best practices, types, components, datasource, ...

* Using StiWebViewerSL
We can give you some advises:
- write SQL-query to filter only needed data before getting it in the report generator.
- select only those fields that you use in the report
- less data conversion as possible especially string to number
- create a simple reports with minimum or without grouping, containers and sub-bands

More detailed recommendations can be given after analysing your report and data.

Thank you.

ok, thanks.

Post by **Andrew** » Tue Nov 22, 2011 3:35 am

Hello,

Let us know if you need assistance.

Thank you.

becomex_jle · Post by **becomex_jle** » Wed Nov 23, 2011 7:11 am

Hello,

I'm trying a simple report with:
- SQL-query
- 6 columns (number, string, data, decimal, decimal and decimal)
- Bands: PageHeaderBand, ReportTitleBand, HeaderDataband and DataBand
- return 100.000 rows with 1493 pages.

Preview Tab: Success
- Generated in 45 seconds.

Preview Silverlight: Error
- Generated 1492 pages in 40 seconds.
- after one minute, occurs erro:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Stimulsoft.Base.StiExceptionForm..ctor(Exception exception)
at Stimulsoft.Base.StiExceptionProvider.Show(Exception exception)
at Stimulsoft.Report.Design.Controls.StiDesignerSLPreviewControl.btRefresh_Click(Object sender, EventArgs e)
at Stimulsoft.Report.Design.StiDesignerControl.TabControl_SelectedTabChanged(Object sender, TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabControl.InvokeSelectedTabChanged(TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabControl.tabStrip1_SelectedTabChanged(Object sender, TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.InternalOnMouseDown(MouseEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Post by **HighAley** » Thu Nov 24, 2011 2:14 am

Hello.

becomex_jle wrote:I'm trying a simple report with:
- SQL-query
- 6 columns (number, string, data, decimal, decimal and decimal)
- Bands: PageHeaderBand, ReportTitleBand, HeaderDataband and DataBand
- return 100.000 rows with 1493 pages.

Preview Tab: Success
- Generated in 45 seconds.

Preview Silverlight: Error
- Generated 1492 pages in 40 seconds.
- after one minute, occurs error.

Please, send us your report with data to reproduce your issue.

Thank you.

becomex_jle · Post by **becomex_jle** » Thu Nov 24, 2011 7:03 am

Post by **HighAley** » Fri Nov 25, 2011 6:24 am

Hello.

We've reproduced your problem. There are several restrictions and your report is too heavy for Silverlight. Please, decrease the amount of records in a report and split it into several parts.

Thank you.

becomex_jle · Post by **becomex_jle** » Mon Nov 28, 2011 6:46 am

Hello.

I can't split because it's cash flow report. (in some cases contains +- 1,000,000.00 rows).

Have you any other suggestions?

Thanks

Post by **HighAley** » Tue Nov 29, 2011 1:01 am

Hello.

becomex_jle wrote:I can't split because it's cash flow report. (in some cases contains +- 1,000,000.00 rows).
Have you any other suggestions?

It's too much data for web-report. We'll try to do something after release but don't promise anything.

Thank you.