On Monday, 25 June 2012 09:48:43 UTC-4, Kevin Powick wrote: > > > By using an EXECUTE statement, then processing the resulting list, you're > reading every record twice, taking a hit on performance. >
I should have been clearer with the above statement. Every record in the file isn't read twice. The entire file is read once to create a list based on the criteria of the executed SELECT statement, then each record that ends up in your select list is, presumably, read at least one more time during processing. So, at a minimum, the number of reads performed is equal to the number of items in the entire file plus the number of items in the resulting select list. -- Kevin Powick -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
