Actually I’m using Domino 8.0.1 but at the moment it is not possible to post a new topic in the Domino 8 forum.
The last few days I’ve been playing with the DB2 capabilities of Domino 8. All is working well. Except performance. Domino and DB2 are both running on a virtual Windows 2003 server. I have a DB2 enabled db with one form, 1 normal view, 1 sql view and 1 DAV. Total number of documents is about 45.000.
Both views show all documents, sorted on the first column.
When I access the normal view through the web and step through the view with next and previous it takes about 150 seconds (2,5 minutes) to open the page. And on the server process db2syscs.exe takes up more than 90% of the cpu.
When I access the sql view (based on the DAV) each page takes about 8 seconds.
In addition I have recreated this same database, not DB2 enabled, with the same docs and the same normal web view. Then each webpage takes less than one second.
After research on the web I realise that Domino with DB2 isn’t always faster, it depends on the application. But I wonder why the db2syscs.exe process is eating up all the cpu? Is this a tuning question?
Karin