Access might be able to handle this. As long as your records don't approach
the access file size limit of 2GB (correct me if I'm wrong on that). Also
as long as you don't expect too many people (more than 5) accessing the
table at the same time, there shouldn't be much of a problem. A recent
article in the Cold Fusion Developer's journal covered this in fact and said
you could use Access for smaller projects without a problem.
Gregory Harris (tekiegreg)
[EMAIL PROTECTED]
-----Original Message-----
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 30, 2000 10:58 PM
To: [EMAIL PROTECTED]
Subject: CF and Access97 - Performance Issue???
I have a client who's proposing to use CF with an access database under th
ecircumstances listed below, and I'd like the views of this list as to
whether you think it's going to work satisfactorily.
While I've used access before, I have only used SQL with ColdFusion so I
dont have any direct experience with this combination.
Here's the deal I'm to work with (if i accept his plan):
Hosted at www.Netnation.com
An Access97 database of 20,000 clients, with 6 tables.
up to 25 sales people accessing and updating this database from anywhere
round the USA.
It's not for widespread use by the client's customers, but I wouldn't be
surprised if that comes up while development proceeds.
The purpose of the site is to be a client tracking application, for
internal use only, but put on the web so the sales people can update their
records anywhere any time.
Will that work? Meaning wil the performance of this be too bad or will
Access be able to cope?
Cheers,
Mike Kear
[EMAIL PROTECTED]
www.afp.zip.com.au
Windsor, NSW, Australia
AFP Web Development
AFP Electronic Forms
AFP Models
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.
