Posted by lister on 02/19/07 15:37

> In a big class where you need lots of data, this would be a performance
> disaster. Some of my tables have 40+ columns - and making 40+ SELECT
> statements, each fetching one item, is a tremendous waste of time.

I think you misunderstand me. There is only one select statement per
table. Yes, I could have 40 columns, and 40 different get*() methods,
but only the first call to one of those methods would result in a
SELECT *. Then all 40 pieces of information would be populated in the
class, and any subsequent get*() calls would simply return the value.

[Back to original message]