Hello! mysql has a very good performance but if you need certain features like views or subselect this database is out of the game. Postgresql fullfills
almost all standard criterias for a "real" database engine but it is a little bit more complex. Running Postgresql on Windows isn't that funny. Some more hints: http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html http://www.google.com/search?q=mysql+versus+postgresql Best regards, Peter ------------ Orginale Nachricht Von: dan martin <[EMAIL PROTECTED]> Betreff: sql2k vs mySQL vs postgresql (for win2k) Datum/Zeit: Montag, 10. März 2003 03:39:36 > Hi, > > I am currently using ms access with a growing 20mb database that I need to > upgrade. My initial plan was to migrate over to SQL 2000 because that seems to > be the most painless (except for price). I am wondering if it would make more > sense to migrate to an open source db: mySQL or postgresql. I am running win2k > with cf5 and would like to keep the db on the same server. > > Does anyone have experience or comparison information between the 3 choices > running on win2k? How much work is it to port access to mysql or postgresql? > For sql2k the upgrade tool does most of the work for you. Are there obvious > benefits performance or feature wise between the choices? > > Any info would be appreciated. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4