Skip to Content
0
Jun 11, 2020 at 01:56 PM

Calling a stored procedure from a command object taking a long time - what could be causing this?

135 Views

hi All, I am calling a stored procedure from a command object in Crystal Reports and it's taking a long time - over 10 mins to update the datasource using Database Expert or Set Data source Location. Any suggestions as to what could be cause this? Does Crystal Report actually runs the command object query at the point of updating the source?

It is also taking considerably longer to execute the stored procedure in Crystal Report (13 mins art best) compared to executing same stored procedure in SQL Server Mgt Studio (3 mins or less).

Thanks !!