Dragging Linus into Transmeta going Open Source with their code is ridiculous. Linus doesn't own the company, he is just an employee (correct me if I am wrong). What's that go to do with double standards ? I also believe in Open Source, but that doesn't mean I will only work for a company that opens up their souce codes for the world... end of the day, people still need to make $$$!
Yes, definately. Access is a desktop based single user Database, even then, I wouldn't use it for more than 10,000 records. Move to MS-SQL Server would be a good option, as the administration is 10x easier, unless you have DBA experience or have a full time DBA. Admin on Unix based DBs are a bit more difficult if you do not have prior DBA experience -> the most important factor is Database Backup and Recovery. Make sure whichever Database you choose, you have a good and well tested disaster recovery plan. We have our e-commerce site using SQL Server 6.5 sp5 (not moving to SQL 7.0 yet) and have over 20,000 records. So far (almost 2 years in operation), there has never been a problem on the database end, but the main e-commerce web server server running on NT occasionally hangs (due to the unstability of NT 4) If you do have a DBA, go for Oracle 8, definately more stable (but more $$$!)
Dragging Linus into Transmeta going Open Source with their code is ridiculous. Linus doesn't own the company, he is just an employee (correct me if I am wrong). What's that go to do with double standards ? I also believe in Open Source, but that doesn't mean I will only work for a company that opens up their souce codes for the world... end of the day, people still need to make $$$!
Yes, definately. Access is a desktop based single user Database, even then, I wouldn't use it for more than 10,000 records. Move to MS-SQL Server would be a good option, as the administration is 10x easier, unless you have DBA experience or have a full time DBA. Admin on Unix based DBs are a bit more difficult if you do not have prior DBA experience -> the most important factor is Database Backup and Recovery. Make sure whichever Database you choose, you have a good and well tested disaster recovery plan. We have our e-commerce site using SQL Server 6.5 sp5 (not moving to SQL 7.0 yet) and have over 20,000 records. So far (almost 2 years in operation), there has never been a problem on the database end, but the main e-commerce web server server running on NT occasionally hangs (due to the unstability of NT 4) If you do have a DBA, go for Oracle 8, definately more stable (but more $$$!)