Theoretical Performance Details of FAD vs. FAC (WAS Re: Stalled

[Tomas Kopal]

On 23.3.2005 23:01, Max Kanat-Alexander wrote:
> 
> 	So with FAD, FULLTEXT fields need their own table, so that we don't
> have to ever do a search on "field_id".
> 
> 	Other comments on the performance testing suite coming up.
> 
> 	-Max
> 

Don't forget, while looking into this, that for transaction support on 
MySQL, which we want to have in the future, you have to have FULLTEXT 
indexed data on a different type of backend engine, so you *need* 
different table anyway.

Tomas