I know everyone is always quick to jump on anyone using Access and tell them not to, so for a change I will just jump in and there are still plenty of sites out there happily running on Access and it is possible to get away with using access without performance penalty, simply by caching all of your queries. You can even cache the whole database if it is not too big and just use query of query. If the data in your database however changes frequently and you cannot cache, then you definitely should not be using Access as it will be a huge bottleneck as stated. But to be fair there are plenty of better alternatives to Access now, all of which are intended for web use, HSQL, Apache Derby, Sqlite to name a few. There really is now reason to be stuck with Access anymore.
Russ -----Original Message----- From: Ben Forta [mailto:[email protected]] Sent: 21 October 2010 15:55 To: cf-talk Subject: RE: Memory Upgrade - Revisited 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:[email protected]] 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:[email protected]] 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 > <[email protected]>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:338434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
