3 ms·
Are you putting binary blobs in the sqlite databases directly?
by philips 8y ago
Are you putting binary blobs in the sqlite databases directly?
- mbrumlow 8y agoYes, the block data is directly inserted into the database. This has worked fine, but I don't think it is optimal. I think we might get some performance increases if we just used seqlite for keeping block offsets into a flat file. But then there are a bunch of other problems to solve. Data is compressed, do we would have to handle free hole allocations for variable sized data. Or simply waste free space. Not that sqlite does does any better with those things, just things we would have to solve in general.