Here is one for you all.
I am running a new site and the database is currently Access97. The
conditions any prospective database must meet are as follows.
1) Fast (already 1/4 million records and growing fast, probably into the
10's of millions)
2) Replicable. Sales staff in the field (World Wide) need to enter
information into a copy of the database on their laptops then dial into
their regional office and synchronise their data with our master, this must
be 2 way replication not just upload.
3) Internet Replication is desirable so we can synchronise the data with the
web server without needing to upload 50-200Mb files via FTP to synchronise
20kb worth of changes.
The web server is a Dell, dual PIII 600, 256Mb Ram, 32Gb Raid5 HDD,
redundant PSU etc... so the server is fast, the current access based system
runs queries in under 250ms. We are thinking of upgrading to MS SQL Server,
but if there is a better option I want to know about it.
Any suggestions?
--
James Smith
[EMAIL PROTECTED]
I love deadlines.
I especially like the whooshing sound they make as they go flying by.
------------------------------------------------------------------------------
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.
