Re: Java and Relations DBs..

["Brad Stone" <brad@xxxxxxxxxxxx>]

> Add static helper methods to your customer and or invoice
> classes that would
> perform this type of operation as a single SQL query.
> Only return the fields
> that you need in that query.

I added a new method that only does a count(*).  It's still
not that much faster.  And since I really don't need fields
in my query (only getting a count), I am not retrieving any
fields from the DB.

>
> If you are creating an object model to just be a memory
> representation of
> the database then you will have problems. The application
> should never be
> designed to load all the data into memory in order to
> perform an operation.

I'm not loading _all_ of the data, just the data that I want
to work with for each instance.  Are you saying that I
should not be using container classes?  Just working
directly with the DB?

Brad