Re: SETLL vs. CHAIN
Re: SETLL vs. CHAIN -- Anon Post Reply Top of the thread Forum

Posted by: Anon Jon Paris
Fri, Dec 22, 2000, 11:33:19


yuo're correct...a SETLL is much less expensive than a CHAIN if all you want to do is see if a record exists.

:I have a program that processes a file of 500,000+ records which runs very slow. Each record chains to a another file to see if a record exists and does some calcs. Out of the total master file, there would be no more than 1000 successful hits on the secondary file. Before I go ripping this code apart (and converting it to RPGIV in the process), my expectation is that if I change the CHAIN to a SETLL and then chain on a successful hit that it should improve the performance considerably. Am I wrong in assuming that SETLL will just look at the "index" which should be in memory as opposed to CHAIN which most often requires an access to disk to retrieve the record?


Post Reply | Email Friend | Alert Original Post Top of the thread Current page