Re: Performance suggestions welcomed

Posted in 1996

Cathy Kipp — 8 Oct 1996 21:08:29 -0400 — source: Informix-list mailing list archive (1991-1998)

In article <svDsQHAPsXWyEw3h@piyalf.demon.co.uk>, Piyal Fernando <piyalf@piyalf.demon.co.uk> wrote: >Any ideas on how to increase performance on the scenario detailed below >; > >Reference info : V7 online on SCO, > a table with 1 column of char(30), 50,000 records. > >Processing : read first record, compare this row with other 49,999, > then read next row , compare with other 49,999, > etc. etc. etc... Interesting problem.... I assume you already have an index on the field? What does the index look like? How unique is the field? Are you doing a straight equality/inequality comparison, or are you using like/matches/substrings? If using like/matches, could you use substrings starting with the first character? A quick sample? More info please! Regards, Cathy ------------------------------------------------------------------------ Cathy Kipp E-mail: ckipp@verinet.com Principal Consultant Fort Collins, Colorado, USA Database Strategies, Inc. Phone: 1-970-226-0240 Informix User Group of Colorado - President International Informix User Group - Board of Directors ------------------------------------------------------------------------