----- Original Message ----- From: "Jim Campbell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 4:51 PM Subject: Re: Urgent: Performance Help
> It's interesting they'd charge you more for MySQL than Access (since I > assume they'll have more tech support issues with Access ;) > Actually it's pretty straightforward why it would cost more -- you have to set up users, dbs, etc in MySQL (or MS-SQL) -- you can't simply copy up a file. In both cases you need to set up the datasource connection (ODBC/CF) but that's it for 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. <arrghhh> Arrrrggghhhhh! IT DOES HAVE TRANSACTIONAL SUPPORT. MyISAM tables do not. BDB and InnoDB tables *do*. You pick your table type and that determines what capabilities that table has -- you can even mix and match table types in the same db so that the operational tables are ACID (orders for instance) while the logging tables are MyISAM. Plus you can load all the lookup data (states, etc) into HEAP tables which reside only in memory. Oh, and there's the MERGE tables for doing basic database partitioning (or for very, very simple db views). Of course HEAP and MERGE tables are non-transactional.... </arrghhh> > > 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. Unless you foolishly picked boolean fields in Access. Access even converts bit fields (0/1) in SQL Server to (0/-1) when you link tables through the ODBC driver. But other than that (and any code that dealt with booleans) you're in good shape. > Best of luck. > > - Jim > Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137544 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
