Re: I-NET FOR 32 BITS?
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
> }
I do think we have the same problem. I have tried a dynamic query on an
integer index and it works fine and quickly :
(Table ser : num_ser integer (indexed column))
with Query1 do
begin
SQL.Clear;
SQL.Add('select * from ser ');
SQL.Add('where num_ser = :numser ');
Params[0].AsInteger := 122;
SQL.Open;
end;
-> Answer : immediate
I think I will contact Informix Tech Support too ..
Thank you
Beatrice