in reply to Re^8: Does Search::InvertedIndex module live up to billing?
in thread Does Search::InvertedIndex module live up to billing?

The indexes are in addition to the primary key, not instead of it.

Loading goes fastest if you write it out to a tab-delimited file and use LOAD DATA INFILE, then enable the keys. (You can either do DISABLE KEYS, load, ENABLE KEYS, or you can just wait to add the indexes with ALTER TABLE commands after the data load.)

  • Comment on Re^9: Does Search::InvertedIndex module live up to billing?