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: Mike Schrag <email@hidden>
- Date: Tue, 9 Feb 2010 18:40:57 -0500
I suspect there's some fanciness we could expose in ERXBatchingDisplayGroup here, too ... It's basically doing exactly the same thing you're trying to do under the covers.
ms
On Feb 9, 2010, at 6:39 PM, Q wrote:
>
> 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
_______________________________________________
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