in the application I'm writting I would make intensive use of BLOB in fact I have a very simple DB tables. However most of them have a BLOB column where I would put application defined data. The data could easily be over 50K (in fact it would be an in memory .tgz archive with user text and (optionally) images)
Basically I would read/write only 1 BLOB at a time and good performance for me would mean no visible latency for the user I just wonder if this could be achieved with good performance, I have read that SQLite is no good with big BLOB. Any similar experience? PS: I cannot test, the GUI is not yet ready! PS2: store the tgz files along the db file is no practical solution for me! I try to have an application file which could be shared with friends, not a 'fragile' directory structure.
