You stated what you want to accomplish, but not why.... The NSF can handle a considerable amount of data -- far more than 500,000 records, unless each of these records is more than 1 MB each. It really depends on how you architect your Notes application(s), which should be very consistent with how you would design an RDBMS (relational database management system) schema. That being said, either SQL Server or DB2 is a viable option, and both will scale way beyond what you've mentioned. If you ever expect to have terabytes of data then I would recommend DB2 over SQL Server. To answer your question about loading all the software on the same system, the answer is: Yes, it is possible. I run an RDBMS, Domino 6 with LEI 6, Notes 6 & Designer 6 all at the same time on my ThinkPad laptop and it all works fine. Would I run this as a production server? Never!!! When you approach server configuration think of Domino as you would any one of the application servers of the market. Consider the load that will be placed on the server -- number of users, transactions, etc. Can you configure the server system (HDD space, RAM, cache, etc.) to handle that load plus the overhead of a RDBMS?
Dig Deeper on Lotus Notes Domino Interoperability
Related Q&A from Scott Lemieux
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.