query efficiency of InnoDB vs lucene I have built 10 million records into lucene and mysql(innodb). The schema is the same. For lucene: