Is the only consequence to this the size of the index file or are there performance consequences.

eg if I have INDEXED WORD LENGTH 60 is that twice as slow as INDEXED WORD LENGTH 30. If not what sort of overhead is it?

Roy Lambert

Roy,

<< Is the only consequence to this the size of the index file or are there
performance consequences. >>

Both.  You should keep the indexed word length as small as possible.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

Stats? I need toi be able to gauge the tradeoff - after all in the silliest case I could reduce the indexed word length to 1

I'm thinking mainly of where users decide to allow indexing of email addresses & urls truncating those might lead to a lot of false hits.


Roy Lambert

Roy,

<< Stats? I need toi be able to gauge the tradeoff - after all in the
silliest case I could reduce the indexed word length to 1 >>

Sure, but you need the thing to work, correct ?   The overall rule is
smaller is better.  It's really that simple.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


OK roughly how much slower would it be if I set the indexed word length to 60 from its default of 30?

Roy Lambert

Roy,

<< OK roughly how much slower would it be if I set the indexed word length
to 60 from its default of 30? >>

I can't say exactly without running some pretty exhaustive tests, which I
can't do right now, but it will be slower.  The bottom-line rule is that you
should go with the smallest length that you can get away with.

--
Tim Young
Elevate Software
www.elevatesoft.com