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: Eugene Khablov <email@hidden>
- Date: Wed, 10 Feb 2010 12:19:12 +0300
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
>
Attachment:
LuceneBatchingDisplayGroup.java
Description: Binary data
Attachment:
LuceneDataSource.java
Description: Binary data
_______________________________________________
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