RE: Single record access really required (was RE: Views and

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

midrange-l-request@xxxxxxxxxxxx wrote:

>   4. Re: Single record access really required (was RE: Views and
>      (Simon Coulter)
>
>It depends. In many cases SQL will be faster but there are other cases
>where native I/O will be faster. Which is faster is usually a case of:
>    o processing sets then use SQL
>    o processing single records then use native I/O
>however both methods can be used interchangeably, in the same program,
>on the same files and for the same purposes.

It's a bit more complicated than that and will only get more so. Consider in 
particular V5R3 SQL's encrypt/decrypt feature. With external requirements such 
as HIPAA, this will be critical for many databases; but I have no picture at 
all how native I/O will play with it. There are a lot of other SQL features 
that also cause native I/O fits. Need to verify a CustNo? Well, if CustMast has 
an encypted field, maybe you better look at SQL.

I'm starting to suspect that speed comparisons aren't nearly as important as 
determining fast access techniques for SQL. Period.

Off on a tangent, I swear another post referred to the inability of DB2/400 
(yeah, I know... the name... but I don't care) to update JOIN views. Maybe ten 
years ago, I think at COMMON, I saw a presentation that described the technical 
obstacles that had to be overcome in order to make it possible. I never 
questioned the problem again.

However, things are slowly beginning to change. Two articles related to the 
idea:

http://www-106.ibm.com/developerworks/db2/library/techarticle/0209rielau/0209rielau.html
http://makeashorterlink.com/?I27224E57
  and
http://www-106.ibm.com/developerworks/db2/library/techarticle/0210rielau/0210rielau.html
http://makeashorterlink.com/?W26212E57

For everyone, if you don't nose around out in places like developerWorks every 
once in a while, search on topics, etc., you can't know what you're missing.

Tom Liotta

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com


__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp