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. Well, you could try: Read record 1; compare with 2-50000, Read record 2; compare with 3-50000, Read record 3; compare with 4-50000, etc. Once you've compared record 1 with all the others, you shouldn't need to compare it again. You can't read it into RAM. 'cos the maximum array size is 32K. HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | Oracle isn't the answer. Oracle is the question, and the answer is "no". | +------------------------------------------------------------------------------+