Have you looked at what SQL you're generating? If you're worried about optimizing 500 rows, you probably have some other issue.

As previously mentioned, you probably have a batch faulting problem. I would monitor the SQL being generated and see what other objects are being faulted in, and change their batch faulting parameters accordingly.

Ken


On Mar 8, 2006, at 5:14 AM, François Reboursier wrote:

        Hi folks,

        Here is a an optimisation-related question.

My app has a user-configurable search page, which displays results in a WODisplayGroup (10 results at a time). Depending on the search, up to 500 complex objects can be fetched, thus the page is rather slow to load, so I'd like to use RawRows to speed things up. Configuring the fetch to use RawRows is a picnic, but how to convert those raw rows 10 at a time, just before they are displayed by the display group ?

In other words, i'd like to see the following patern:
- load 500 objects as raw rows
- convert the first 10 objects to EntrepriseObjects using EOEditingContext faultForRawRow() - when the user moves to the next batch of the display group, convert the 10 next raw rows to EntrepriseObject
        ... and so on

Any pointers ?

Regards,
François


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/lists% 40anderhome.com

This email sent to [EMAIL PROTECTED]

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to