RE: [PHP] MySQL vs. Postgresql

> > Would MySQL be a reasonable database to use for an image database where > the images themselves were actually stored in the database? > > I am talking about ....jpegs, gifs stored in binary format in the SQL > database, possibly 10 or 20,000 images. > > Okay, so the number of records myth was just proven wrong, but > how about database SIZE and performance? Gigabytes upon gigabytes? > > (yes I realize I'm going to have to have > gigantic-monster-enormously endowed > server) > > Thanks > Dan In my opinion - no. But would postgres be? no. You might consider putting the actual images on the filesystem with reiserfs or some other new filesystem that can handle directories with 20K entries easily, and storing the filenames in the database. That's what I'd do, given your description. MySQL itself does not have a limit on tablesize, but linux has - if you use default ext2. Using the filesystem has, as far as I can see, nothing but advantages :) Regards, Sander