Re: Batch fetching / raw rows / SQL / full text search
Re: Batch fetching / raw rows / SQL / full text search
- Subject: Re: Batch fetching / raw rows / SQL / full text search
- From: Q <email@hidden>
- Date: Wed, 10 Feb 2010 09:39:11 +1000
On 10/02/2010, at 9:18 AM, Mark Wardle wrote:
> Hi.
>
> I'm evaluating lucene and postgresql's own full text search with a few
> benchmarks.
>
> I'm now trying to get the results (sometimes lots) as an array of
> enterprise objects.
>
> I can use EOUtilities.objectForRawRaw but it looks like there is a
> trip to the database for each EO. I haven't benchmarked this bit of
> the process yet, but sometimes I may get >500 results.
>
> is there a way of efficiently doing this for an array of, say, primary
> keys, that I can return from the full-text engine?
>
Wonder's ERXEOControlUtilities has a few methods that might be useful to you:
faultsForRawRowsFromEntity
faultsForGlobalIDs
objectsForFaults
objectsForGlobalIDs
--
Seeya...Q
Quinton Dolan - email@hidden
Gold Coast, QLD, Australia (GMT+10)
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden