Desperately need objective comparisons between Notes and Access/SQL as DB servers for web
Posted on 2001-06-04
this is a similar, but significantly different, question to one I asked before.
Our customer uses Lotus Notes internally (5.04 I think) and we've got a system (Notrix & Openlink ODBC drivers) that export this information overnight to an Access Database (this will be upgraded to SQL server in 6 months or so). This works fine. However, the American arm of the company is kicking up a fuss and saying that the whole project should stay in Notes & Domino environment, rather than kicking the data out to Microsoft standard stuff.
What I need is an objective comparison (white paper, hard experience, html link, pdf, whatever) that compares Lotus Notes & Domino as a platform for a dynamic web site and IIS/Access/SQL using asp pages.
All I can find is comparisons between Lotus Notes and Exchange, which is not what I'm interested in. We can get the data from the notes files, I just need to know if it's more efficient to be using the SQL/Access/IIS route or whether Lotus Notes is a reliable and fast technology to be using for what will be a speed-critical website.
Should they even be considering using Lotus Notes to serve the site from a Domino server? I have no experience of using the Lotus technology so I am unable to be objective about this.
Comments/pointers gratefully accepted!