Re: WebObjects and Search Speed
Re: WebObjects and Search Speed
- Subject: Re: WebObjects and Search Speed
- From: Chuck Hill <email@hidden>
- Date: Wed, 22 Oct 2003 15:56:31 -0700
At 12:40 AM 23/10/2003 +0200, you wrote:
>Thanks a lot, Alan, Chuck and Cyril for your answers.
>
>So the way to go seems to be to use Lucene. Can I use Lucene to search the
>frontbase database (as LookSee from Frontbase seems pretty expensive, when I
>can use lucene for free).
Yes. LookSee will probably be easier to use.
>Can't I use WebObjects to query the database?
Yes, you can. You said it needed to be fast. If you use raw SQL to
search, is it sufficiently fast? If so, you are done - use WebObjects. If
not, you need special, highly optimized searching code to assist the DB.
>Why do I need Lucene? Only to build the index?
Speed. Flexible searches.
>Please appologize my ignorance, but I
>always thought WebObjects has such great database functionallity, so why
would
>I use lucene?
>
great database functionality != google.com
>I'm working on my inital project, so I don't have any experience
>with WebObjects (well I read my way trough the apple manuals and tutorials).
>
Duplicating Google like functionality might be a bit of an ambitious first
project. :-)
>How shall I start? Model the database in EOModeler, then build the app (web
>application) and then use lucene to create the index? Or can I just use
>Lucene's search functions in WebObjects? Perhaps I should provide you with
some
>more details of my project, so you can better help to choose the right
>approach. Please let me know.
>
Try reading up on Lucene first to see that it does and does not do and how.
Chuck
>Am Wed, 22 Oct 2003 15:26:01 -0700
> schrieb Chuck Hill <email@hidden>:
>> 30 tables x 20 rows = 600 rows total. That is not a very large database
>> IMHO. Unless you are storing huge BLOBs almost anything should be fast.
>>
>> Assuming you actually need to make this faster...
>>
>> I'd start here:
>> http://jakarta.apache.org/lucene/docs/index.html
>>
>> FrontBase is a good (great?) database speed wise. They also have a full
>> text search feature (not free!) called LookSee. I've not used LookSee. It
>> appears to be good, but database specific. FrontBase has excellent support
>> for WO but LookSee is not standard EOF access so you might need to do some
>> integration work.
>>
>>
>> HTH
>> Chuck
>>
>>
>>
>> At 11:55 PM 22/10/2003 +0200, Pascal Schrafl wrote:
>> >Hello together
>> >
>> >I would like to build an search application with WebObjects, that
searches a
>> >database (will be quite big). Now my concerns is the search speed. Can
>> anyone
>> >tell me, how the speed issues are? Approximately there will be arround 30
>> >tables, with about 20 rows, the content will be mostly text (varchar).
>> Please
>> >let me know, how the speed is or how it can be improved (perhaps by
>> building an
>> >index). What kind of database would you recommend me (Openbase, Frontbase,
>> >etc.)? Good WebObjects support is important for me.
>> >
>> >Thanks a lot,
>> >
>> >Pascal
>> >_______________________________________________
>> >webobjects-dev mailing list | email@hidden
>> >Help/Unsubscribe/Archives:
>> http://www.lists.apple.com/mailman/listinfo/webobjects-dev
>> >Do not post admin requests to the list. They will be ignored.
>> >
>>
>> --
>>
>> Chuck Hill email@hidden
>> Global Village Consulting Inc. http://www.global-village.net
>
>
--
Chuck Hill email@hidden
Global Village Consulting Inc. http://www.global-village.net
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.