Ryan,
This is exactly the scenario oft quoted to emphasize locking the DB during a
read or write query. Was that part of the code in this instance?
Thanks
Richard
-----Original Message-----
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 4:05 PM
To: CF-Talk
Subject: Re: Using MS Access with Cold Fusion (no no)
At 17:14 10/12/00 -0400, you wrote:
>
>Are you speaking from experience or just from what Allaire officially
recommends?
I have done load testing with a banner app that uses an Access database. It
runs fine until you hit it with more than one request at the exact same
time.
Then it blows up. I've also had problems adding more banners to this banner
ap when we had more than a hundred or so banners in it. Problem is the
source
is encrypted so I could not even see what the author was doing.
What makes access work ok on your sites is that even if you have 3 requests
per second, as long as each of those requests only take a fraction of a
second,
they probably will never collide. But when two requests hit the DB
at the same time, it blows up. Its not a multiuser database! This banner app
used an Access97 db, too. 2000 may work better. I'm glad you have all had
such success with it.
RPS
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
