4 ms·
Well, don't do that, normalize your scheme.
by revelation 9y ago
Well, don't do that, normalize your scheme.
- phn 9y agoWhen 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 :)