Comment Re:Why not Informix? (Score 1) 220
Informix very well should be on the list of RDBMS' to look at. Informix SE will not solve your problem, as it uses flat files in the file system to hold table data. However, Informix Open Dynamic server uses Raw Disk Space, therefore getting rid of the whole 2GB file size limit.
Informix treats BLOBs rather oddly and will take some getting used to. Servers in replication (HDR) also tend to exhibit problems that Informix has no clue how to correct (most client libraries don't operate properly, ALTER TABLE will cause assert failures I would certainly not consider it one of the FASTEST RDBMS'. Altho I have never crammed a PostgreSQL DB full of data, my inital impression would be that PostgreSQL is as fast if not faster than Informix.
MySQL is probably not a good choice. Lack of transaction support (and MySQL's statement that transaction support will NEVER exist in MySQL) make it a poor choice for anything but quick and dirty (and small) web databases (at which it excells beyond comparison).
Take a look at Informix. Especially if having corporate support options is something that is important to you.
Informix treats BLOBs rather oddly and will take some getting used to. Servers in replication (HDR) also tend to exhibit problems that Informix has no clue how to correct (most client libraries don't operate properly, ALTER TABLE will cause assert failures I would certainly not consider it one of the FASTEST RDBMS'. Altho I have never crammed a PostgreSQL DB full of data, my inital impression would be that PostgreSQL is as fast if not faster than Informix.
MySQL is probably not a good choice. Lack of transaction support (and MySQL's statement that transaction support will NEVER exist in MySQL) make it a poor choice for anything but quick and dirty (and small) web databases (at which it excells beyond comparison).
Take a look at Informix. Especially if having corporate support options is something that is important to you.
