Re: Replacing Traditional I/O with SQL

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