Re: [sqlite] store image file as blob

On Wed, Oct 30, 2013 at 9:10 AM, Teg wrote: > I do keep the > blobs in one table and meta-data in another. > Good point, and worth repeating. If you store large BLOBs in your database, performance will be much better if you keep them in a separate table something like this:

Re: [sqlite] store image file as blob

Hello d, I prefer them in the DB so, I can move them as a package. I have 30-40 GB DB's filled with image files. Performance is decent. I do keep the blobs in one table and meta-data in another. C Wednesday, October 30, 2013, 7:30:58 AM, you wrote: db> Hi, db> My sqlite database module has

Re: [sqlite] store image file as blob

On Wed, Oct 30, 2013 at 7:30 AM, d b wrote: > Hi, > > My sqlite database module has to store images (max. 100 KB) on client > machine. > > 1. store images on file system and have reference in database > 2. store image as blob in database. > > Which is the best way to