Re: I-NET FOR 32 BITS?

I had a no index use under windows3.1 On the server DBNLS was set to 2 On the client side the collchar was set to 1 (is placed in informix.ini vi the setnet ustility; there has to be something similar under I-net for 32 bits ???) Changing collchar to blank solved the problem Kahler, Russell P. wrote: > > 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 > }> } > }