Depend on what they're going to be doing with it. If you keep the extensive
queries on the database, as well as all the joins, you should be all right,
the ones you can't keep on the database, of static data you can cache.
Proper coding of course will make a big difference as well. I imagine,
depending on how productive these 25 people are they'll become discontent
with it sooner rather than later. Access seems to do better pulling data
than writing data, in medium/high traffic.
My $0.02
Fred
----- Original Message -----
From: "Mike Kear" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 01, 2000 12:57 AM
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.
