News for hackers. Stuff that matters.

A comment on Anko SQLite, a library to simplify working with SQLite on Android. Parent comment

Re:Anko SQLite, a library to simplify working with SQLite on... by revelation on Thursday September 21, 2017 @10:27AM (#15303733)
Well, don't do that, normalize your scheme.
[ Parent | on HN ]
Re:Anko SQLite, a library to simplify working with SQLite on... by phn on Thursday September 21, 2017 @12:03PM (#15304814)
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 :)

[ Parent | on HN ]