Hello Jay, Monday, September 18, 2006, 10:05:19 AM, you wrote:
JS> On 9/18/06, Teg <[EMAIL PROTECTED]> wrote: >> Hello Jay, >> >> The whole reason I store files in the DB in the first place is to have >> a single "package" to move around and backup when needed. My >> application is storing whole series of PNG and JPG files in the >> DB with meta data describing where the images came from. JS> My technique won't help you then. I use it for things like scanning images JS> of documents and using the database to keep track of the documents. JS> I never have to search a picture using a select statement so it would JS> be silly for me to put them into the database. I just back up the file JS> system using off the shelf backup software and it works fine. JS> -- JS> SqliteImporter and SqliteReplicator: Command line utilities for Sqlite JS> http://www.reddawn.net/~jsprenkl/Sqlite JS> Cthulhu Bucks! JS> http://www.cthulhubucks.com JS> ----------------------------------------------------------------------------- JS> To unsubscribe, send email to [EMAIL PROTECTED] JS> ----------------------------------------------------------------------------- There's no right or wrong way. I was just suggesting that there are cases where you want to store the whole file in the DB. I have an application that generates 1000's of 150K compressed files. I've been toying with the idea of shoving them all onto a DB because of the way Windows groans when you have to enumerate folders with many small files. In the case of these small files, performance is dominated by enumerating and decompressing so, even if it's a bit slower selecting the files out of the DB, any improvement in enumeration speed would make a noticeable performance boost. The downside of course is I'd have to vacuum the tables from time to time. -- Best regards, Teg mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------