Others off the top of my head -
1) Access Transaction/Rollback support is shaky at best.
2) If a database transaction screws up, it's very easy to corrupt the entire
database and leave it unuseable
3) Those DAMN .LDB FILES!!!!!
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2001 13:56
To: CF-Talk
Subject: RE: limitations of Access
> I am doing a quote for a client that has an existing CF site using Access.
> They are a professional organisation hosting their own server and
> I'm trying to get them to steer away from Access, as I think the site
> has the potential to get more hits than Access can easily handle. So far
> they are determined to stick with it.
>
> I need some ammo... I know Access is not suitable for the job they want it
> to do, but I'm not sure of the facts and figures. I think someone once
> before said that Access cannot handle more than 5 concurrent users but I'm
> not 100% sure.
>
> So does anyone have any concrete figures on the capabilities of Access?
OK... here's some to start with;
Access is a Desktop application and not a Server application
Access has a 50 concurrent user limit - it errors as soon as this is broken
Access uses Table Locking, not Record Locking - so if you want to update/add
a record, no other users can add/update to that table - this is hellishly
important!
Access's ODBC has memory leaks - it will mean the server must regularly be
restarted
Access isn't Transact SQL - this means you need 1 CFQuery per query - if you
want to do tons of INSERT INTOs in a row, this slows up the template
Access runs in the processor memory no matter which server isn't on - this
means you can't have a separate database server to handle the SQL and a CF
server to handle the templates
I know there's more, but I just can't think of them...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
