Hello. I am new to Ferret. I am using it through Acts as Ferret. Let's say I have such a table, and all columns are indexed using the default behavior provided by acts_as_ferret:
ARTICLES -id -year -body [1] A typical request will be "select id from articles where KEYWORDS % body". Will id be indexed for fulltext searching? clearly the fulltext index on id will never be used... id is only in the index so that it can be returned. [2] I anticipate that a response might be "because id is numeric and has a cardinality of 1/1, ferret is intelligent enough to store this efficiently in a b-tree and not waste space or time on a fulltext index". what about if there is a year column, against which we will never search? [3] This is an acts_as_ferret-specific question: are there any convenient methods to do queries against the regular (mysql) database and the ferret database at the same time? for example, still using the example above, if year (and maybe several other columns) were NOT stored in the ferret DB, is there any level of abstraction at which i can query: "select id, year, author, title from articles where KEYWORDS % body" ? thanks for any pointers. john _______________________________________________ Ferret-talk mailing list [email protected] http://rubyforge.org/mailman/listinfo/ferret-talk
