February 7th, 2004, 09:37 AM
I am thinking about using msde for my website, Can someone tell me if MSDE is a good choice, secondly if 50 users hit the web site at the sametime you think MSDE will be able to handle it?
Also is this true that MSDE does not have foreign keys to connect tables?
February 7th, 2004, 09:48 AM
1. I would go for an opensource and free db, like Firebird or MySQL (PostgreSQL is not officially available on Windows)
2. I think that msde has a limit on concurrent connections which is lower
3. No, it's false (all the databases I suggested support FK)