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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Limitations to use stored procedure in Dashboard Designer

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, for every UI interaction, we move the Stored Procedure data into temporary table. So the performance of Stored Procedure in Dashboard Server is slow when compared with Dashboard Designer.

 

For Stored Procedure, Dashboard have some other limitations too.

2. Joining operations cannot be applied for Stored Procedure.

3. Edit connection option is not feasible with Stored Procedure.

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

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

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8647 04/05/2018 04/05/2018 Dashboard Platform Dashboard Datasources
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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