Vernon,
That is too much traffic to expect Access to handle.
IMO you will possibbly get more performance improvement from
going to SQL Server than going to a dedicated server.
The amount of Access database activity done by other users
on the server you're using shouldn't affect you that badly.
The dedicated DB server sounds like overkill.
Nick
-----Original Message-----
From: Vernon Horn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 7:46 AM
To: CF-Talk
Subject: Access/SQL/hosting question
I'd appreciate any and all advice and comments on the following situation.
I work for a non-profit membership association (translation, not a huge
budget, but web stuff is getting to an important means of communication
with the membership.) We've been running our web site on a shared server
set up, but for a variety of reasons are pretty sure that we want to move
to a dedicated server.
Currently we are serving 20-40,000 pages on a good day, around half involve
database queries, and there are a couple of hundred credit card
transactions per day also. Most of our traffic is concentrated during
standard business hours.
So, here is the question, one consultant has recommended that we not only
move to a dedicated server, but also upsize the databases to SQL, and get a
dedicated database server as well. This seems like a fairly drastic leap,
and I'm wondering if our relatively low volume really demands this? I know
Access gets a lot of flack, but is it reasonable to expect it to perform
better on a dedicated server?
Any recommendations for what the most cost effective solution for us would
be greatly appreciated.
Thanks in advance,
Vernon Horn
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
