Subject Re: [firebird-support] Full Text Searching For Firebird
Author Alexandre Benson Smith
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 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:

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
I have created a Directory
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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil