Re: Performance suggestions welcomed

} } 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 don't know why you are doing this but I presume you are eithrer looking f for duplicate or unique records. The best way to reconcile this is to unload the data using an order by and then use unique on it. Michael Strother