Fetching Raw Rows
Fetching Raw Rows
- Subject: Fetching Raw Rows
- From: Jevon Hills <email@hidden>
- Date: Fri, 25 Apr 2003 11:17:41 -0600
I'm still learning WO and have not been able to successfully retrieve
raw rows from my database.
I have build up my qualifier and can fetch my data as entities, but the
problem is that the query I need to run will normally return between
150,000 and 250,000 objects. This of course causes an out of memory
error. I don't actually need the data as entities, and it seems like
Raw Rows is a good answer for me.
Can someone explain and perhaps provide an example of how to fetch raw
rows and then how to use the fetched data, or is there another way to
deal with such an abundance of information other than raw rows that I
have not considered yet.
I'll give my current example (not using raw rows):
NSMutableArray args = new NSMutableArray(new Object[]{"consoleid",
consoleID, "lastupdated", tempStart, "lastupdated", tempStop});
EOQualifier qualifier = EOQualifier.qualifierWithQualifierFormat("%@ =
%@ AND %@ >= %@ AND %@ =< %@" , args);
EOFetchSpecification fetchSpec = new
EOFetchSpecification("CURRENTCONSOLELOAD", qualifier, null);
NSArray consoleLoad = ec.objectsWithFetchSpecification(fetchSpec);
tia,
Jevon K. Hills
Developer - Zymeta Media Promotion Systems
_______________________________________________
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.