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: Wed, 10 Feb 2010 07:11:17 +0000
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