On 4/23/01, Vernon Horn penned:
>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.
I don't think you're going to see much, if any, improvement if you're
using Access as it is pretty much the weakest link in the chain. In
reality, you should set the concurrent connection limit to Access at
5 or less, and if the data is important to you, then you should set
it to a single concurrent connection to assure the db doesn't get
fried if there is even a "chance" that 2 people could be updating the
same record at the same time.
For a cost effective solution to start, I'd suggest simply using MSDE
on a single server. I ran that setup for awhile with a substantial
amount of traffic to about 5 SQL databases and didn't have any
problems. With the money you'll save initially, I'd suggest putting
AT LEAST a gig of RAM on the server and as much CPU power as
possible. You can upsize the Access dbs at your leisure and by then
you'll know if you need to migrate your new SQL databases to a
dedicated SQL server.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
