Thread:Help talk:Fixed properties/Considerations for assigning fixed property?

Short of doing a bunch of deep digging into the generated SQL and doing performance comparisons I'm wondering if anyone can shed some light on the tradeoffs of using fixed properties. Maybe Nischayn22? Some things that come to mind:


 * 1) How important is the datatype for fixed properties? On WikiApiary I'm using a lot of booleans. Do booleans get a benefit greater or lesser than text? Does it matter at all?
 * 2) While moving to separate tables should make searches faster (smaller indexes?), does it increase the number of joins that the database has to do?

I hope this doesn't sound lazy. It's great to now have this option, but I'm guessing everyone would benefit from understanding performance tradeoffs (it's never something for nothing right?) and impact before we all start making fixed properties. WikiApiary has 2.5M properties, and if moving my extremely often used boolean fields to fixed properties would improve performance I'd do it in a second.