Indexes built in DDL use a larger blocking. This gives them better
performance, but from what I understand that holds true whether using
traditional I/O or SQL to access the data. I've not seen nor heard of a
big performance hit using SQL over DDS-defined files.

Michael Quigley
Computer Services
The Way International
www.TheWay.org

cobol400-l-bounces@xxxxxxxxxxxx wrote on 01/25/2011 01:00:10 PM:
----- Message from Jeff Buening <JeffBuening@xxxxxxxxxxxxxxxxxxx> on
Tue, 25 Jan 2011 09:16:32 -0500 -----

To:

cobol400-l@xxxxxxxxxxxx

Subject:

[COBOL400-L] Replacing Traditional I/O with SQL


For people that have replaced traditional I/O including Read and
Writes
with SQL, was there a significant hit on performance if the underlying
file
structure was still DDS? Just wondering if not even worth doing the
embedded SQL, unless we switch the file to DDL.

I have written some new programs that only do some selects and write to
a
print file and have been fine still DDS structure. My concern is I
start
replacing traditonal I/O Reads and Writes and I am going to see this
huge
impact unless we switch to DDL first. Or this is my impression I have
gotten online. Does my concern seem valid or has anyone done this and
the
impact not as bad as I think?


Thanks,

Jeff

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.