But realistically no-one runs MySQL in a live production environment. Do they? None of the major clients I service do. Oracle is a given now but MSSQL seems to be gaining ground lost with XML support. Still no sign of SQL Server 2003 in this part of the world yet.
Developer editions of Oracle are certainly available - very resource intensive (huge install requirements) - and MS SQL Server 2000 "Personal Edition" could be an option. I had the option of MSSQL Standard or Personal after a system rebuild and have gotten "personal" for now. On a dev machine it is more than enough - I did not bother installing Access at all. And to "assume" that Access will "upsize" to SQL depends entirely upon the version of Access you are using. More often than not it is easier to recreate the database in SQL Server with test data. If you are serious about performance be serious about using a dbms that can cut it. Oracle, MSSQL and then maybe MySQL. -----Original Message----- From: paris lundis [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 September 2003 7:38 AM To: CF-Talk Subject: Re: Urgent: Performance Help At the starting level you seem to be at with the site and databases, I'd recommend taking the MySQL route.... its free... runs on more platforms.. runs darn fast... If you think your clients/company will be a Windoze shop or clients will be wanting MS solutions I'd say pickup MsSQL afterwards... Simple selects, writes and updates aren't very different between them... syntax can be annoying... Transactions and complicated sub queries, mass unions, etc. typically are beyond what most folks actually need... Finally, MySQL + CF can be setup on a smallish computer within your home /office and run pretty well... Be sure to setup dev environment of your own before deploying your monster apps... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137440 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
