×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




 >> You are correct about some cases where "native" I/O has been faster than
SQL.  The same argument was made in the 1970s & 80s  between SQL and DB2 and
IMS "native" access on the mainframe.

Dave - I think you are missing one significant point.  It wasn't really the
same argument.  The mainframes (and other platforms) didn't have a choice as
to how they access the _same_ data.  To the best of my knowledge only
iSeries allows SQL _and_ native access to the same table.  We do have a
choice - and where it makes sense we would be foolish not to take advantage
of it.  

I'm all in favor of increasing the usage of SQL - but I've seen quite a few
boxes lost or under threat because a mandate to switch everything to SQL
caused such a performance loss that the bosses were persuaded that
Oracle/SQL Server/nameYourDB would be the solution to the poor performance.

Jon Paris
Partner400

www.Partner400.com
www.RPGWorld.com 


This thread ...


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

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