View previous topic :: View next topic
|
Author |
Message |
Sowmya Ramachandra
New User
Joined: 11 May 2007 Posts: 20 Location: Canada
|
|
|
|
Hi ,
Could anyone let me know whether accessing a record stored in KSDS file by passing a Key is better or Storing a data in sequential file and loading it into an internal array in the program and then accesing it is better from the performance perspective. |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
It depends on several factors: Number of records in the VSAM file, total number of VSAM reads vs. table searches will be done on the average, how often the VSAM file is updated, total amount of memory an internal table will use (usually not a problem these days). You need to provide more detail to get a good answer. |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
Since I cannot edit my posts, I wanted to add that memory searches will outperform I/O almost always, but there are other considerations, too. |
|
Back to top |
|
|
Sowmya Ramachandra
New User
Joined: 11 May 2007 Posts: 20 Location: Canada
|
|
|
|
The no. of the records in the file is supposed to me low volume say abt 50-100 records. |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
And what about the other factors I mentioned? They all play a part. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
How many records are in the "real" file (rather than this reference data?
Can the real file be put in sequence by the value that is used to search the array/vsam data?
As Terry mentioned, the other info requested could help us help you. |
|
Back to top |
|
|
|