When your application grows, eventually you need to de-normalize data if you want to keep having reasonable performance for some operations. You can reach a po

When your application grows, eventually you need to de-normalize data if you want to keep having reasonable performance for some operations. You can reach a point where it's not feasible to have everything done by joins. EDIT: I mean in relational DBs in general. In this case, 400+ columns probably mean SQLite may not be the engine to use, regardless of schema :)