|
>> 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
As an Amazon Associate we earn from qualifying purchases.
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.