I know others have said this already, but it's worth reiterating. Database access is almost always an application bottleneck, especially for highly data-centric apps like the "typical" ColdFusion app. Microsoft Access *will* be a choke point for your app. A powerful new machine, lots of memory, 64bit OS and JVM, all are great, but they are wasted if you're going to be waiting for Access. Kind of like buying a brand new sports car, loaded, but then putting a two-stroke engine in it.
As for migrating, Access to SQL Server is really easy, there is a wizard in Access that'll do it for you, and in my experience it usually works flawlessly. Cheaper options, like MySQL, will require more effort to migrate to, but still worth doing. --- Ben -----Original Message----- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Thursday, October 21, 2010 10:03 AM To: cf-talk Subject: Re: Memory Upgrade - Revisited On 10/21/2010 6:42 AM, Steve LaBadie wrote: > Just to be clear my assumptions are correct that I do not need to > purchase the "Enterprise" version in order to utilize the memory? > > -----Original Message----- > From: David McGraw [mailto:david.mcg...@gmail.com] There is something > wrong with the idea of using such a beastly web-server with an Access > DB backend, upgrade your DB while you are at it. > > On Wed, Oct 20, 2010 at 11:48 AM, Steve LaBadie > <slaba...@po-box.esu.edu>wrote: >> We purchase 12 GB of memory for our web server and come to find out >> that we need Windows 2003 Enterprise or upgrade to Windows 2008 in >> order for the memory to be recognized. We currently have MX 7 standard installed. >> I am going to upgrade to CF 9, Standard. I understand that CF 9 >> Standard comes in 64 bit and can run 64 bit heaps. And I believe you >> can still run 32 bit ODBC drivers on a 64 bit windows so I can still >> use my Access DB's. I believe it is more complex then that. Yes you probably get 32bit ODBC drivers to *work* on your 64 bit windows, but they will only work with other 32 bit applications. I.E. using them may very well require you to use 32 bit IIS which would in turn require you to use 32 bit ColdFusion. So as said earlier, you may very well need to and probably should upgrade your databases. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
