RE: Performance suggestions welcomed

Posted in 1996

CSC CIS — 8 Oct 1996 17:13:31 -0400 — source: Informix-list mailing list archive (1991-1998)

Piyal 1. Create an index on the column 1 of the table. 2. PREPARE the statement to do the compare with the other rows. Hope this helps Sujit Pal DBA, Computer Sciences Corp. ---------- From: Piyal Fernando[SMTP:piyalf@piyalf.demon.co.uk] Sent: Monday, October 07, 1996 3:50 PM To: informix-list@rmy.emory.edu Subject: 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. reply piyal@piyalf.demon.co.uk