Re: Informix upgrade slows Delphi

Posted in 1998

Joe Vigil — Wed, 04 Mar 1998 01:27:24 GMT — source: Informix-list mailing list archive (1991-1998)

>> 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. >> > Verify that you don't join character and numeric fields. If you do, there's a noticeable performance hit.