I'd like you all to give me hints and advise on the following scenario:
We are considering using Microsoft's SQL Server 2008 R2 Express for a business Web Application.
The Web Application won't have more than 10 CRUDs, and won't have a high data traffic, all of them are simple web forms. About data scalability, the Web Application is basically focused on employee data, like personal information, vacancy control, and the daily frequency control.
From what I've seen, I've estimated a maximum of 5 simultaneous users, generating data traffic.
And also, our employee table should hold a maximum of 100 records.
As to physical limitations I think we're fine, since I don't think a maximum of 100 employee should generate 10 GB for the next, say, ten years? But since I've read that the Express edition only manages 1 GB of RAM and uses only 1 CPU, I thought it'd be best to ask.
Do you think it can manage to keep up a good response and performance in this case?
So please advise on using SQL Server 2008 R2 Express or some other database manager. Just keep in mind that it has to be free.
Windows Server 2008;
4 GB of RAM;
1 TB HD.