Delphi 2 and Informix : slooooooow !!!!
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 = "127472" '); SQL.Open; end; answer : immediatly 2) num_malade := '127472';// 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; ou := '127472'; SQL.Open; end; answer : after 2 or 3 minutes !!! This problem does not exit with Delphi 1 using SQL Links 16 bits and d'Informix-Net (16 bits) and exactly the same program. Thanks for help Merci pour toute aide 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