|
>and you call all three will it end up doing three i/o's or just one? My understanding is that it will do 3 I/Os (sort of!) You'll have 3 reads of the row, but in the case of the 2nd and 3rd "read" the row is already in memory so it's not like you're going to disk. I will say this about functions, I've found them to be great -- usually. However, they are a place to look if performance becomes an issue. I know we took a sql statement from ~120 seconds to ~1 second by changing a function call to a join. -Walden ------------ Walden H Leverich III Tech Software (516) 627-3800 x11 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.
midrange.com
