4 ms·
If I remember correctly, SQLite parses the DDL for tables and indexes each time the database file is opened. I always thought this was kind of weird, and felt
by thwarted 17y ago
If I remember correctly, SQLite parses the DDL for tables and indexes each time the database file is opened. I always thought this was kind of weird, and felt a binary representation would be more appropriate, but when you consider that DDL exists to describe the schema, it makes perfect sense. There's no need for another representation, and parsing the DDL is more future-proof as features are added.