Xataface Forums

Hi

When I did my initial design of my research database, I anticipated using the MyISAM engine for my 'context' tables, and to that end compiled a custom 'stop word' list for the aggregated languages. One of my concerns at that time was that many acronyms would eventually be used as common search in searches of our case write-ups - prime example - ETA. Many of you probably know there's also a default indexing value for the shortest string to be indexed in Text fields under FULLTEXT -- it happens to be 4 -- so strings with 3 or less characters are excluded My understanding is that you can recompile MySQL to change that value, or to modify the stopword list. Although I anticipated perhaps having to deal with those issues, it wasn't with a great deal of joy.

As I don't anticipate having petabytes of data to wade through, I'm wondering how sensitive the xataface indexing is, can it be 'tuned', AND do I need to stick to MyISAM tables for content I want to index. I did a search (probably not the best) for this info, but didn't turn anything up. I suspect it all 'soft', which would fit my purpose, but I'm asking first, LOL.

thanks very much

Xataface actually doesn't use the full text indexing feature of MySQL for any table searches (e.g. searching on particular fields or searches with the search box). The only thing it uses full-text indexing for is the site search feature (which is disabled by default).

In most cases it is just using a LIKE query, which has no such limitations.

-Steve