hi,
is there anyone who actually did a huge project where he would put images into a database rather than on the file system?
i would like to know this:
1 - having 30.000 users, each with couple of images [all together like 1MB]... is this a heavy load for MySQL database? database would be accessed quite frequently, i assume some 30.000 unique users per day, requesting data or even more. mostly SELECT queries (99%).
2 - should i go with postgresql for project like this [lots of binary data]? just asking coz i dont know postgresql.
any info, tricks or experiences with "images in the database" are very welcome. why not and why yes.
Matjaz
is there anyone who actually did a huge project where he would put images into a database rather than on the file system?
i would like to know this:
1 - having 30.000 users, each with couple of images [all together like 1MB]... is this a heavy load for MySQL database? database would be accessed quite frequently, i assume some 30.000 unique users per day, requesting data or even more. mostly SELECT queries (99%).
2 - should i go with postgresql for project like this [lots of binary data]? just asking coz i dont know postgresql.
any info, tricks or experiences with "images in the database" are very welcome. why not and why yes.
Matjaz