3 ms·
SQLite tosses out the SQL once it is parsed into bytecode. Using text is just going to take longer, even though I’m sure it works great. You can modify the dat
by conradev 1y ago
SQLite tosses out the SQL once it is parsed into bytecode. Using text is just going to take longer, even though I’m sure it works great.
You can modify the database before vacuuming by making a new in-memory database, copying selected tables into it, and then vacuuming that to disk.
- nine_k 1y agoThis should be the accepted answer.