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.
