Vernon, how many complaints are you getting from your current clients
regarding poor performance (if any)? Also, are you able to check the CF
Logs to see if there are indications of problem issues with Access or
anything else for that matter.
Kind Regards - Mike Brunt
Macromedia Consulting
Tel 562.243.6255
Fax 401.696.4335
http://www.macromedia.com
-----Original Message-----
From: Christopher Cortes [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 9:04 PM
To: CF-Talk
Subject: RE: Access/SQL/hosting question
Vernon,
I would suggest trying out the dedicated machine prior to jumping into SQL
Server unless you can get a good deal on a server package. It sounds like
you understand your needs. There are also a few tweaks that you can do with
access database to improve performance. You won't see SQL Server numbers
though. I am curious, how many database hits per second are you seeing on
average throughout the day? This would probably be a good indicator as to
how much headroom if any you have left in your access database.(I am
assuming you can get this data from CFSTAT, bet I am wrong) One last thing,
I don't know that you can necessarily assume you will see better Db
performance on a dedicated server; you don't really know how many database
hits other users on that server are making. Your provider might give you
some numbers.
- Chris
<!----------------------------------------------------------->
Christopher Cortes |Coming Q3 2001:
Consultant |
Stonebridge Technologies, Inc. | 'Optimizing ColdFusion'
Putting Technology To Work | By
Visit us at www.sbti.com | Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100 | www.osborne.com
<-----------------------------------------------------------!>
-----Original Message-----
From: Vernon Horn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 1: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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
