|
>From: Joe Pluta [mailto:joepluta@xxxxxxxxxxxxxxxxx] >Common sense would indicate that the extra overhead of >SQL will ALWAYS make it a little >slower for single record operations, but that it's set-based >capabilities will make it faster for set-based operations. I think that was true prior to 5.2. In <=5.1 SQL actually accessed data through the same SLIC primatives as single record operations. However, in 5.2 SQL has a new query engine (below the MI) and its own set of SLIC primatives so I'm tempted to say that common sense may see a change. -Walden ------------ Walden H Leverich III President Tech Software (516) 627-3800 x11 (208) 692-3308 eFax WaldenL@xxxxxxxxxxxxxxx http://www.TechSoftInc.com Quiquid latine dictum sit altum viditur. (Whatever is said in Latin seems profound.)
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.