Re: Informix upgrade slows Delphi

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 = ? -- Bruce Momjian | 830 Blythe Avenue root@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)