RE: I-NET FOR 32 BITS?
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
}