Lotus Domino Slow Access to View - HDD shows peak access
Posted on 2009-02-16
I have a custom Lotus Domino Application. Changing to particular views is REALLLLY slow. As in 1min 4 seconds. The views that take a long time have children documents. If I select all the documents in that view there is ~16,000 docs ( inc. children )
I thought Lotus Notes opened just enough documents for the viewing pane, and collected more from the server as you paged down? So I thought this wouldn't be a problem. If I remove the children docs from the view it performs well.
If I put the database local on my workstation accessing ( with the children documents ) it takes 7 seconds; That's what I want but from the server - but currently I'm at 1min 4 secs!
OK then: Why is it so slow?
Came in at 10pm when there is next to no activity on our network. Same problem -- virtually the same access speed for the database.... Viewing the network activity graph in Windows 2003 Small Business Server confirms this low level of activity --- no bottle neck. Viewing the performance of each network CARD also shows relatively little activity.
Processor graph shows very little.. 20% / 30% usage. It's a pretty good HP server 6 cpu's or something like that.
Bingo.... HDD activity is shown peaking for 5 seconds at a time when accessing the view(s) in question. ( ie. 100% usage ). The actual label on the graph for HDD activity is 'Disk Queue Length'' It get's absolutely hammered!
My workstation doesn't have this problem though?? The server is raid 5 - as a trial I put an IDE drive in the HP server ( as my workstation was in that config ) and run Lotus Domino off it's own HDD... Still the same problem ( actually a few seconds slower - still a max-out on the HDD access on the performance graph ).
What am I missing :)
Many thanks for your assistance,