PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Which one is fast SETLL or Chain

View previous topic View next topic Go down

Which one is fast SETLL or Chain

Post  rajkumar400 on Wed Dec 29, 2010 2:29 am

Which one is quick Chain or Setll?

Thanks.
Raj

rajkumar400

Posts : 59
Join date : 2010-12-25

View user profile

Back to top Go down

Re: Which one is fast SETLL or Chain

Post  soundhar on Wed Dec 29, 2010 11:42 am

CHAIN = SETLL + READE
CHAIN will set the pointer and fetch the record also...
SETLL will set the pointer alone,it wont fetch records....
Performance depends on the file size....
Both r used according to the need alone... No need to fetch records then use SETLL alone...
Logically setll wil b faster bec it just verifying...
Chain -verify & fetch records...

soundhar

Posts : 67
Join date : 2010-07-14
Location : Vridhachalam/chennai

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum