... both will be fast enough in all real world scenarios and thinking about
performance of parts of an application, which are fast enough is waist of
time!
waisting some time:
As long as DB2 on AS400 is based on ISAM tablesmthe true ISAM access
operations could be faster as long as IBM marketing doesn't decide to slow
them down. Doing it the pure ISAM way an insert operation adds a record to
the end of the table and doing this one aftern another allows very efficient
blocking. Doing the insert the pure SQL way, you would reuse deleted records
and an insert operation has more effort (finding the place to insert,
positioning/loading and then the insert and blocking would be limited by the
size of free blocks.
D*B
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
