Hi Everyone,
I am building a small application to handle a photo database.
I am at the point now to decide whether to use a file-system based repository or a database-based repository (thankfully using the MySQL's blob field).
The archive of picture will be pretty large (more than 4.000 Photos) and each photo will have a size between 500Kb and 2Mb.
Clearly a file-system based image database will result in best performances, but I have some security concenr (it is too easy to move an image file from the repository, whitout the database even noticing it).
What do you suggest me to do? I will be glad to know your opinions.
Also, assuming to use a database-based repository, what type of impact in performaces are to take in consideration?
Thanks,
Vin
I am building a small application to handle a photo database.
I am at the point now to decide whether to use a file-system based repository or a database-based repository (thankfully using the MySQL's blob field).
The archive of picture will be pretty large (more than 4.000 Photos) and each photo will have a size between 500Kb and 2Mb.
Clearly a file-system based image database will result in best performances, but I have some security concenr (it is too easy to move an image file from the repository, whitout the database even noticing it).
What do you suggest me to do? I will be glad to know your opinions.
Also, assuming to use a database-based repository, what type of impact in performaces are to take in consideration?
Thanks,
Vin