Re: Performance suggestions welcomed

Piyal Fernando 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... > > Even ignoring the compare (string matching) part above, it takes a hell > of a long time, hours and hours and hours. Any tips like, read the lot > into memory, buy a CRAY, etc. etc. would be welcomed. I presume you have an index, but it may not be used. How similar is the data? Switch SET EXPLAIN ON and send us the results. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+