Re: Performance suggestions welcomed

You may try increasing the amount of shared memory you use. That way, most or all of the table will be buffered which is much faster than going to disk. Someone else suggested not processing all the rows over and over again (once you have compared the 1st row to the rest, no sense in comparing it again). > 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. ^^^^^^^^^^^^^^^ > > reply piyal@piyalf.demon.co.uk > > >