hello alexandre thanks for the reply

our application is held on a server. ive researched a bit about
dotlucene. however this article put me off a bit.

http://discuss.joelonsoftware.com/default.asp?joel.3.230182.22

basically they are saying that dotlucene is fine if your data is
static. but if its being hit and updated all the time you risk
concurrency issues between the database data and the dotlucene data.
this for me is a big worry.

what do you make of this? do you have any other suggestions? do you
know if firebird intend to include a full text search in a future
release? thanks

--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

>
> martinthrelly wrote:
>
> >hello there. i am being asked to design a google-esque search

facility

> >which will hook up to a relational firebird database. we are

porting

> >our application onto the web using the firebird.net provider.
> >
> >i have checked out the java based dotlucene component but i am

loathe

> >to storing our indexes outside the database because our database

will

> >be constantly updated by the users so i am worried about

concurrency

> >issues. also some search results will require to use joins before
> >displaying the info.
> >
> >all in all any advice would be appreciated.
> >
> >
> take a look here:
> http://www.codeproject.com/cs/database/FulltextFirebird.asp
>
> in special at this paragraph:
>
>
> Where to Store the Index
>
> On a server, it's no problem to store the index in a separate

directory

> (you can also load it to RAM to make your searches super fast - if

you

> have enough RAM, of course). In a desktop application, it might be
> useful to store the index in a Firebird database.
>
> DotLucene supports a mechanism for adding custom index storages.

All

> storage types (file system and RAM are built-in) are implemented

as a

> class derived from Lucene.Net.Store.Directory abstract class
>

<http://www.dotlucene.net/documentation/api/1.4/Lucene.Net.Store.Dire
ctory.html>.

> I have created a Directory
>

<http://www.dotlucene.net/documentation/api/1.4/Lucene.Net.Store.Dire
ctory.html>

> implementation that stores the index directly in a Firebird SQL

database.

>
>
> Please report back I'd like to know how well it works :-)
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>