Delphi 2 and Informix : sloooooooww !!
Posted in 1997
Topics: General Discussion
Hi , I have problems with Delphi 2.01 C/S and Informix(SE version 5) using SQL Links 3.5 and I-Connect 7.2 : queries with params are very very slow 1) with Query1 do begin Close; SQL.Clear; SQL.Add('select * from malade where num_malade = "M127472" '); SQL.Open; end; answer : immediatly 2) Edit1.Text := 'M127472'; num_malade := Edit1.Text ;// num_malade is the primary key with Query1 do begin Close; SQL.Clear; SQL.Add('select * from malade where num_malade = :num_malade '); Params[0].AsString := num_malade; or := 'M127472'; SQL.Open; end; answer : after 2 or 3 minutes !!! This problem does not exit with Delphi 1 using SQL Links 16 bits and Informix-Net (16 bits) and exactly the same program. Thanks for help Dr. Michel CURE D'partement d'Information M'dicale ASSOCIATION HOSPITALIERE DU BASSIN DE LONGWY 54350 Mont-Saint-Martin (FRANCE) E-Mail : Michel.Cure@wanadoo.fr