another point is: how do you get a consistent snapshot (i.e. for backup)? if you store things inside and outside the database neither database backup nor filesystem backup will achieve this. one solution would be to shut down the database and take a cold backup of the database and the file system with your pictures. if you can afford down times, this is ok. otherwise you probably should put everything into the database and performe a database hot backup. or you will nead a really elaborated mixed-strategy-backup software.
cu, Christian ----- Original Message ----- From: "Ing.Branislav Gerzo" <[EMAIL PROTECTED]> To: <dbi-users@perl.org> Sent: Sunday, April 10, 2005 12:47 AM Subject: db or file access? > Hi all, > > This is not direct perl question, but it is database related. > I am on freebsd, using mysql, and thinking about storing pictures in > database. But someone tolds me, that is faster to have only id in db, > and picture stored in harddisk in good dir structure, for example: > /1/10/100/1000342.jpg > > what do you think is faster? I think storing pictures in db is always > faster as have them on hdd as files, but I'd like to know opinion from > experts :) > > thanks >
