>>> I know that we will have to rewrite anything that we have > >Don't you still lose the ability to use views, stored procedures, >triggers and custom functions with the latest versions of MySQL?
4.0.x, using InnoDB tables gives you transaction support. 4.1 supports subqueries 5.0 (alpha) supports views, stored procedures and triggers Years ago I converted some large applications SQL Server 7 to MySQL 3.23 and saw immeidate speed improvements. In January, I released an enterprise application for a large financial company using CFMX 6.1 J2EE and MySQL 4.0. We were originally going to tie the application to an existing Oracle 8i database, but fortunately went with MySQL for reasons I can't go into. I was able to easily migrate 4 years of data from Oracle to MySQL thanks to its transaction support and CFMX's XML handling. The speed of MySQL 4.0 over Oracle 8i is also very noticable. HTH, Adrian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196570 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
