I'm maintaining an app which adds/removes columns from increasingly large tables -- not often, but regularly (during deployment of new versions, and hence also frequently during development).
Right now, we're using InnoDB. Performance of adding a column isn't great: it has to copy the entire table.
I've read that the Falcon engine doesn't store default values for fields. Does that mean that adding a new column to a table doesn't require copying the table?