Hello!

How do I define/create a full text index?


I have been looking through the docs, and I must be missing something....

I looked here http://www.elevatesoft.com/dbisam4d7_full_text_indexing.htm
and at the table docs, and nowhere do I see the syntax for creating a full text index, or
a discussion of how / when the full text index is created....

(Discussions of performance, index size, index maintenance, etc. would be helpful as well!)


Soooooooooooooo

Where do I start?

Thanks!

Sam

Easiest way to create FTI's is to use DBSys then if you want it in code just reverse engineer the table. Performance using TEXTSEARCH rather than LIKE is about on a par with the difference between using an index to locate a record and navigating through the table one record at a time and doing field=value.

Index size - depends on how much text you're indexing - but think enormous and you can't go wrong Seriously the index will be large. In my app the blb is c600Mb the index c100Mb BUT only because I've set up custom functions to strip out html code and any words < 3 or  >40 characters.

Maintenance - the only real problem is if you define your own custom handling - this isn't recognised in DBSys (unless you add it) so any restructuring of the table, or data entry or deletion done away from your custom function will need a repair of the table with your function  linked in.


Roy Lambert

Sam,

<< How do I define/create a full text index? >>

You do so when creating or altering the structure of a table:

http://www.elevatesoft.com/dbisam4d7_creating_altering_tables.htm

This is noted on that page:

"You must alter the structure of a table in order to change any of these
parameters."

However, it could use a link to the above topic.   I will make sure that it
is included in the next build.

<< (Discussions of performance, index size, index maintenance, etc. would be
helpful as well!) >>

It's all automatic after the full text index is created for the table.  The
full text index behaves just like any other index.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:


http://www.elevatesoft.com/dbisam4d7_creating_altering_tables.htm

<<<<<

Thank you!

I have reviewed that page.... and I have to say that the full text index information is
really sparse.  I can infer, barely, what is going on.

It would be very helpful to have some examples. Along the lines of:


To add a full text index to the example table, we would execute the following syntax:

   <example syntax>

This allows us to use full text queries against the X and Y columns. <See full text
documentation for details of these queries>

Important options for full text indexes include:

<index flavor A>:  <description>
<index flavor B>:  <description>


You get the idea. Some clear docs would make this area a lot more accessible.