Another thing to consider is that even a table as small as you're
describing can require beefy resources to host properly, if it is being
accessed all the time. You have to consider both space and load
levels. I would say as a general rule that Postgres and MySQL have
similar performance levels, with MySQL probably being a teeny bit
faster (though I have seen benchmarks the supposedly show postgres as
being a little bit faster, but this is constantly changing as different
advancements are made in each project), and then sqlite is supposedly
about 2x faster than MySQL, but it does not work well in a distributed
environment, since each client must lock the entire database while its
query runs.
Carl
smime.p7s
Description: S/MIME cryptographic signature
____________________
BYU Unix Users Group
http://uug.byu.edu/
___________________________________________________________________
List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list