We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Limitations to use stored procedure in Dashboard Designer

Platform: Dashboard Platform |
Control: Dashboard Datasources |
Published Date: April 5, 2018 |
Last Revised Date: December 21, 2018

We have some limitations to use the Stored Procedure in our dashboard. Please find the details below.

1. Performance of Stored Procedure in dashboard is slow when compared with Tables and Views. The reason is, for stored procedure, internally we move the entire records into a temporary table in a SQL connection and then fetch those data for any operation in dashboard. So, the stored procedure will take some time for data migration. But for Tables and Views, data fetching will be done directly from the SQL Server instead of using temporary table. Therefore, performance of using Stored Procedure is slow in dashboard.

IMPORTANT NOTE: In Dashboard Designer, we move Stored Procedure data into temporary table only once and then fetch the data from that temporary table for any operation. But in Dashboard Server, we maintain the temporary table in cache for every 10 minutes, based on this time interval we have cleared the cache then move the Stored Procedure data into temporary table again.

 

2. Joining operations cannot be applied for Stored Procedure.

 

3. Stored Procedure that returns only data table as a resultant set are supported in dashboard designer.

 

4. Stored Procedure having out parameters are filtered out from the dashboard designer view.

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon