One of the things you should acquaint yourself with if you enjoy using sqlite, is the without rowid feature. It reduced the many to many table's size by nearly 2.4 Gb in a 3 gb file that we have.

It also improved performance significantly, so uh, if you can use it, then you should :D

Follow

It is of note that this is only worthwhile in tables with a covering primary key, or a non integer primary key.

Sign in to participate in the conversation
The Vulpine Club

The Vulpine Club is a friendly and welcoming community of foxes and their associates, friends, and fans! =^^=