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... -paris ---------- Original Message ---------------------------------- From: Jim Campbell <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Sep 2003 15:51:14 -0500 >It's interesting they'd charge you more for MySQL than Access (since I >assume they'll have more tech support issues with Access ;) > >However, MySQL is not that hard to learn. You don't have transactional >support nor real foreign keys, etc. There are a number of differences >that we've discussed before on this list, and you should be able to pick >them up for the archives. > >SQL Server might be a better choice - it should be able to recognize >your tables/datatypes from Access without any problems, and if you're >using things like transactions, the migration should be fairly >painless. _Fairly_ painless, not necessarily totally painless. > >Best of luck. > >- Jim > >Andy Ousterhout wrote: > >>Jim, >>I've asked them to look specifically at the Access connection, because I >>have heard that also. They have MySQL and SQL Server, for more $$$. I also >>would have to learn them, which would take time. I was hoping to put off >>moving to a "real" engine after I had a site that might drive some traffic. >>I may have to change my plans..... >> >>Thanks >>Andy >> >>-----Original Message----- >>From: Jim Campbell [mailto:[EMAIL PROTECTED] >>Sent: Wednesday, September 17, 2003 3:32 PM >>To: CF-Talk >>Subject: Re: Urgent: Performance Help >> >> >>Your problem might lie with Access - I've had plenty of problems with >>Access and ColdFusion - especially with keeping threads open and bogging >>down the system - and always on servers that handle many simultaneous >>requests. Can you use a different database with them? PostgreSQL? SQL >>Server? MySQL? >> >>- Jim >> >>Andy Ousterhout wrote: >> >> >> >>>No, don't recommend Viagra....the problem is I just won't stop..... >>> >>>My ISP is accusing me of writing code that keeps threads open long after >>> >>> >>they >> >> >>>should be closed and are threatening to shut down my site. Good news is >>> >>> >>that >> >> >>>I don't have many users yet, Bad news is that they can't give me any >>> >>> >>details >> >> >>>because they don't have their analytical software, Cognos, up yet. >>> >>>Is there a site anywhere that can help we walk through my code and try to >>>figure out what the problem is? Running MX and Microsoft Access. It runs >>>fine as a single user on my PC. >>> >>>Thanks for anything you can give me.... >>> >>>Andy >>> >>> >>> >>> >>> >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137399 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 Get the mailserver that powers this list at http://www.coolfusion.com
