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: Mark Wardle <email@hidden>
- Date: Thu, 11 Feb 2010 13:17:52 +0000
Thanks for this. I'll digest the code over the weekend when I have
some free time.
Thanks again,
Mark
On 10 February 2010 09:19, Eugene Khablov <email@hidden> wrote:
> Hi, Mark!
>
> It was pretty simple to extended ERXBatchingDisplayGroup and
> EODataSource with results from ERXIndexing and then just use them on a
> page.
> See attached code.
>
> --
> Eugene Khablov
> Media Agency "Demax"
>
>
> On Wed, Feb 10, 2010 at 10:11, Mark Wardle <email@hidden> wrote:
>> Thanks both - I'll have a look at the source for all of those options.
>>
>> Perhaps I should also be thinking how to expose full text search in a
>> database agnostic way to applications but for the present, I'll be
>> hardcoding some SQL for this specific case.
>>
>> Many thanks,
>>
>> Mark
>>
>>
>> --
>> Dr. Mark Wardle
>> Specialist registrar, Neurology
>> (Sent from my mobile)
>>
>>
>> On 9 Feb 2010, at 23:40, Mike Schrag <email@hidden> wrote:
>>
>>> 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
>>
>
--
Dr. Mark Wardle
Specialist registrar, Neurology
Cardiff, UK
_______________________________________________
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