Devart Forums

Posted: **Mon 15 Jan 2018 15:33**

I got a simple stored procedure on the SQL Server :

ALTER PROCEDURE [dbo].[sp_izmenska_opravila] 
		@P1 int
	
AS
BEGIN
		SET NOCOUNT ON;
 
	SELECT * from IZMENE_OPRAVILA where IZMENA_ID=@P1

In Delphi I got :

Code: Select all

procedure TForm10.cxButton3Click(Sender: TObject);
begin
DataModule2.IZMENE_OPRAVILA.ParamByName('p1').AsInteger:= strtoint(cxLookupComboBox1.Text);
DataModule2.IZMENE_OPRAVILA.Prepare;
DataModule2.IZMENE_OPRAVILA.ExecProc;
end;

To get 23 rows of data, this procedure takes almost a minute to complete !
Hitting the button again takes forever ...
Why is this ?
This is unidac 7.0.2 for Tokyo.

Posted: **Tue 16 Jan 2018 10:03**

We tested UniDAC work, but unfortunately, found no speed problems when working with stored procedures. In order for us to analyze the issue, please send us a sample, which demonstrates it, as well as a script for creating a stored procedure and a table.

Devart Forums

TUniStoredProc unbelievably slow

TUniStoredProc unbelievably slow

Re: TUniStoredProc unbelievably slow