RE: I-NET FOR 32 BITS?

I don't know a whole lot about these collating sequences... Is this the LC_COLLATE ENV in set net. If so mine has always been unset. Is there something I should set this to? Russ }---------- }From: Luc Douwen[SMTP:Luc.Douwen@coi.be] }Sent: Thursday, February 20, 1997 12:31 PM }To: informix-list@rmy.emory.edu }Subject: Re: I-NET FOR 32 BITS? } }We had the same problem. }It turned out that the collating sequence in the setnet }configuration had to be blank !!! }If not the client uses another collating sequence than the server }an no index is used } }Luc Douwen }luc.douwen@coi.be } } } } } }Kahler, Russell P. wrote: }> }> I don't know if we are having the same problem but it does sound very }> similar. }> Our problem was that indexed joins were very slow. We setup our system }> to set explain on and took a look at the output. What we found was that }> every query that used an index on a char(x..) field would not use the }> index and perform a sequential scan. We found that if our queries were }> accessing non char indexes everything was fine. We also found that }> running the exact same app against ON-LINE we found everything worked }> correctly. We corrently have a case open with Informix tech support. }> We are working with them to setup a test env so we can get it logged as }> a bug. }> }> Ex. }> table 1 }> field1 char(6) }> feild2 integer }> }> both fields have there own index. (index1 on field1,index2 on field2). }> }> select * from table1 where field1 = "XXXXX" }> }> sequential scan }> }> select * from table1 where field2 = 2 }> }> indexed filtered.... }> }> Russs.... }> }> }---------- }> }From: Michel CURE[SMTP:Michel.Cure@wanadoo.fr] }> }Sent: Friday, February 14, 1997 5:08 AM }> }To: Kahler, Russell P. }> }Subject: Re: I-NET FOR 32 BITS? }> } }> }Kahler, Russell P. wrote: }> }> }> }> We are also using 7.2 and had some porblems with binding varibles with }> }> SE. }> }> Works fine against ON-LINE... }> }> }> }> Russ... }> }> }> }> }---------- }> }> }From: Cecilio Albero[SMTP:orange@vlc.servicom.es] }> }> }Sent: Monday, February 10, 1997 6:55 AM }> }> }To: informix-list@rmy.emory.edu }> }> }Subject: Re: I-NET FOR 32 BITS? }> }> } }> }> }> }> }> }> Hi Folks, I would like to know is there exist a version of }> }> }> Informix NET PC for Windows 95 ??????? }> }> }> }> }> }> If somebody knows , plese let me know. }> }> }> }> }> }> Thanks in advance }> }> }> }> }> }> Javier Puente }> }> }> Corporacion Noboa }> }> } }> }> }Yes, I'm working with }> }> }INFORMIX NET PC (or I-Connect) 7.2 for Windows 95/NT since October. }> }> } }> } }> }I saw in the news that you had problems with binding variables with SE. }> }I'd like to know if you encountered the same problem as me : }> } }> }I work with Delphi 2.0 C/S and Informix(SE version 5) }> }using SQL Links 3.5 and I-Connect 7.2 : dynamic queries are very very }> }slow }> } }> }1) with Query1 do }> }begin }> }Close; }> }SQL.Clear; }> }SQL.Add('select * from malade ') ; }> }SQL.Add('where num_malade = "M127472" '); }> }SQL.Open; }> }end; }> } }> }-> answer : immediatly }> } }> }2)// num_malade is the primary key }> }with Query1 do }> }begin }> }Close; }> }SQL.Clear; }> }SQL.Add('select * from malade '); }> }SQL.Add('where num_malade = :nummal '); }> }Params[0].AsString := 'M127472'; }> }SQL.Open; }> }end; }> } }> }-> answer : after 2 or 3 minutes !!! }> } Even If I prepare the query !!! }> } }> } }> }Thanks for help }> } }> }Beatrice }> } }