>
There is no need for manually storing files on filesystem, because large objects are doing that for You. I am storing whole binary files in blobs(synonym for large objects from some other platforms), and I do not remember that I had a single problem with that. Do not forget that libpq has great support for large objects, and you can store large object without actually storing them on server filesystem, so You do not need any file permissions on "upload directory" or something like that.
The pictures are prepared for web. Storing in files is faster from that side. That system is calling db every 30 mins...
Zeos are useing a lot of memory...If You are using Delphi, there is great project called "Zeos objects", and if I remember correctly it has support for large objects.
Regards, Michał Zaborowski (TeXXaS)
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
