Devart Forums

What's is more Fast??,in execution

example 1:

with QueryClients do begin
Close;
SQL.Clear;
SQL.Add( 'Select Name From Clients ' );
SQL.Add( 'Where name like ' + '''' + edit1.text + '%' + '''' );
Prepare;
Open;
end;

example 2:

with QueryClients do begin
Close;
SQL.Clear;
SQL.Add( 'Select Name From Clients ' );
SQL.Add( 'Where name like :pParam' );
ParamByName( 'pParam' ).AsString := Edit1.Text + '%';
Prepare;
Open;

end;


which the execution form fastest??

Both are the same since this is related to Delphi and not MySQL

The performance is the same in both cases. But using parameters is more correct.

Antaeus wrote:The performance is the same in both cases. But using parameters is more correct.

thanks all.

why you dont do a JOIN to other table to get all the relative records instead of opening/closing table inside a loop?

ben, afaik he isn't using any loop

oops I thought it was "while" not with
Sorry