RE: Best DataBase software?
I think SQL server would be fine. But I would however plan in the future for a dedicated database server at the very least. This should deal with any types of performance issues as the db grows. To deal with some of your replication issues I would recommend setting up a portion of your site that is like an admin area where field personnell can access and update certain information in real time. Thus your other offices will have the most up to date information as possible. Byron -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 13, 2000 8:05 AM To: [EMAIL PROTECTED] Subject: Best DataBase software? 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. -- 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.
Re: Best DataBase software?
Sounds like a good question for the sql server lists: www.swynk.com SQL7 and MSDE on the laptops might be workable. Im not familiar with 2 way replication scheme's so the best place to ask would be sql7 list on ww.swynk.com hth, Steve > 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. > -- 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.
Best DataBase software?
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.