Re: Online 5.04: Miserable Performace

Posted in 1997

Mr. Nasty — 24 Jan 1997 21:09:39 GMT — source: Informix-list mailing list archive (1991-1998)

Gabriel Beccar-Varela (beccarvarela@pop.waonline.com) wrote: : I am working with Online 5.04 in a Sun Spark 10 (SunOS 4.1.3). The : following query (run from isql) takes for ever to complete with no users : in the system. In fact, after 4 or 5 minutes I interrupted it. : SELECT count(*) : FROM contacts, companies : WHERE companies.active = -1 : AND contacts.active = -1 : AND companies.company_id = contacts.company_id : AND (description MATCHES "*cancer*lung*" OR : interest MATCHES "*cancer*lung*") Informix is the slowest in a query of char fields. Plus having a * at the beginning of matches statement does not help either. You should turn sqexplain on and see what indexes (if any) this query is hitting.