Just to answer some more on this, Access is very good for very small sites.
I have developed a very highly succesful site using Access. We had some very
hefty problems with the server falling over etc., but was able to cache the
queries enough to make the site never fall over again.
Data that was stored in the databse that does not change very often is
always cached by me, using the application variable, if someone makes a
change to the content that gets stored into the database a flag is used to
say the data has changed and to reread the current query again.
This method works very well on small sites, but when you start talking the
amounts of data that is needed for very big/large scale E-Commerce sites
then forget Access. B2B solutions and B2C you might be able to get away with
Access for sites that don't expect too many users, but I always sugest
sitting down and looking at what is needed from the database. If it looks
like it will constantly be hit then look at ways to reduce the overall
impact on the DB if this can't be done then scaling to Oracle or MySQL or
msSQL are the best options.
regards
Andrew Scott
Cold Fusion Application Developer
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAIL PROTECTED]
-----Original Message-----
From: Max Paperno [mailto:[EMAIL PROTECTED]]
Sent: 13 October 2000 08:15
To: CF-Talk
Subject: Re: Using MS Access with Cold Fusion (no no)
Are you speaking from experience or just from what Allaire officially
recommends?
As others have suggested, Access works great for smaller sites, especially
when it's mostly read-only. I have a server that gets several million CF
page views per month which hit various Access data sources. No issues
(except bad coding). As Howard says, the right tool for the right job. In
over 4 years working with CF and Access, I've actually never seen an Access
DB cause problems (except for some MDAC memory leaks back in the day). For
a while I actually had an large Access-based extranet app in production
(that had a ton of read/write going on) being used by over 100 people all
day long for about a month. Despite my warnings to the client that the DB
might "blow up at any moment," it never did (we later migrated it to SQL
Server).
Cheers,
-Max
At 10/12/2000 02:23 PM -0500, you wrote:
><RANT>
>I'm amazed at the amount of posts I see on this list by people
>mentioning that they are running with MS Access. When you do
>this, don't be surprised when you have problems. I've talked to
>Allaire on the phone and they've told me that they reccomend
>that you never use Access in a production environment. Access
>is a single user database. Not something to hook in to the web!
></RANT>
>
>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.
