Re: Informix upgrade slows Delphi

root@candle.pha.pa.us wrote: > > In comp.databases.informix John Carlson <carlson1@bellsouth.net> wrote: > : Art S. Kagel wrote: > :> > :> root@candle.pha.pa.us wrote: > :> > > :> > I had a client who just upgraded from Informix 7.1 to 7.2, and all of a > :> > sudden, all the queries are slow. Moving from field to field which does > :> > a single SQL table lookup takes 30-40 seconds. Seems like it is doing a > :> > sequential scan or something. > :> > > > : Have you checked OPTCOMPIND in the ONCONFIG file? If I remember > : correctly, Informix defaults this value to 2 instead of 0. A setting of > : 2 means that the optimizer will prefer a cost-based solution over index > : joins. That may mean using sequential scans. > > First thing I checked. It is set to zero. The queries are simple > > select mmatter > from matter > where mmatter = ?> > Onstat shows the query as some type of prepared query, with the only > text as: > > where mmatter = ? > How about a table schema? Please post . . . John Carlson Informix DBA WH Smith, Inc.