Re: DB Queries processed by DB Server or WebObjects?
Re: DB Queries processed by DB Server or WebObjects?
- Subject: Re: DB Queries processed by DB Server or WebObjects?
- From: Art Isbell <email@hidden>
- Date: Thu, 10 Jul 2003 18:50:50 -1000
On Thursday, July 10, 2003, at 05:27 PM, Riaz Lalehzari wrote:
When I request rows from a DB, is it Webobjects doing all the work, or
is it the server with SQL-Server on it?
The WO app creates the fetch command (i.e., the JDBC command), the DB
processes the fetch based on this JDBC, and the WO app processes the
result set (i.e., database rows). So both are working, but I suppose
it depends on how well the DB is indexed, configured, etc. vs. how
complex the fetch spec and EO's are on the WO side.
Is there any difference with this when you use different ways of
accessing the data?
eg. using rawrowsforsql, or fetch specifications, or
objectsMatchingKeyAndValue.
Fetching raw rows requires less work from the WO app because EO's
aren't created, but you lose the advantages of the editing context.
objectsMatchingKeyAndValue() and other EOUtilities methods are
convenience methods that combine several other public methods, so they
are usually creating fetch specs behind the scenes.
Aloha,
Art
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.