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

Attachment: 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

Reply via email to