The issue that tends to affect CF is because Access is not a multi-user database, but when use don a website this is how it is treated as multiple user hit the site and thus the database at the same time. This can result in the jet drivers getting locked up or too many requests being queued, which in turn causes the ODBC bridge to hang, which in turn causes Coldfusion requests to queue up or Coldfusion to become unresponsive.
On Mon, May 30, 2011 at 3:29 PM, Eric Roberts < [email protected]> wrote: > > It still becomes a problem because it is not designed to handle large > amounts of a data. I have worked at many places over the past 13 years > that > were in the process of moving to MySQL/MSSql/Oracle from Access because the > site was so bogged down by the database after it hits about 60% capacity. > Even through the jet engine, there are still locks and you do run into > issues. > > -----Original Message----- > From: Claude Schnéegans <[email protected]> > [mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans <schneegans@interneti=71?= > =?ISO-8859-1?Q?ue.com=3E?=] > Sent: Monday, May 30, 2011 09:12 AM > To: cf-talk > Subject: Re: Cannot install CF 9 > > > >> I would suggest to avoid using Access anyway, it can be the cause > stability issues on CF > > I know I know, This is true for multi user Access applications, programmed > inside the Acces database. > The problem must be in the way locks are managed in VBscript. > As far as CF is concerned, this is pure urban legend: there is only one > user: CF, and VBscript is out of the way. > Only the jet engine is used. > I've been using Access databases since 1995 and I've never ever seen any > problem with them. Beside, Access databases have a few advantages. > > I'd me more interested knowing how you can get 64 bit CF work with 32 bit > ODBC drivers. ;-) > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344995 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
