Hello,
I am working on web portal. There are some ads. We have about 200 000 ads. Every ad have own directory called ID, where is 5 subdirectories with various sizes of 5 images.
Filesystem is too slow. But I don't know, if I store these images into postgres, performace will grow.
Second question is, what kind of hardware I need for storing in DB. Now I have Intel(R) Pentium(R) 4 CPU 1.70GHz with 512MB RAM and 120GB HDD.
thanx for advices...
miso
Hello Miso.
I used to have the same problem with web hosting and storing/sorting/retreiving images for banner exchange and for user "sites/pages".
My tests was done on FreeBSD 4.5 with postgreSQL 7.3.2 (or soething) and with Mysql (i do not remember it's version.
And we found out that only storing of filenames in the database and getting the actual binary data from filesystem giving some performance.
-- Best regads, Anton Nikiforov
smime.p7s
Description: S/MIME Cryptographic Signature
