Re: WebObjects and Search Speed
Re: WebObjects and Search Speed
- Subject: Re: WebObjects and Search Speed
- From: "b.bum" <email@hidden>
- Date: Wed, 22 Oct 2003 16:00:02 -0700
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
I would go so far as to say that is a small database -- 20 tables x 30
rows each is only 600 rows total. Even if each row were 10 kbytes,
that is only 6 megabytes of raw data. Even if it were 60MB of raw
data, that is still a relatively small working set.
In this case, do something like:
- load all the data (all of the EOs) into memory
- use a shared editing context (a read only editing context,
effectively) to avoid copying the data
- do all of your searches in memory using whatever algorithm you need
It will be tons faster than searching in the database and will likely
require less code. Lucene and other indexing solutions are likely
overkill.
b.bum
[demime 0.98b removed an attachment of type application/pkcs7-signature which had a name of smime.p7s]
_______________________________________________
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.