Home
TeamSite
TeamSite, LiveSite and OpenDeploy
TeamSite Database performance issues with 7.1
System
Hey DevNetters -
I've been testing 7.1 in a (Solaris 10 LDOM) dev environment and have run into some performance issues.
Most everything runs OK but sort of slowly. I'm trying to determine if it's the LDOM / environment we're running in, or if it's something about 7.1 TeamSite itself. Here's an issue I've recently run into:
When, in Content Center, I select several directories for deletion in a workarea, the page waits to refresh for several minutes before timing out and this error displays:
The Interwoven Web Daemon was unable to contact the Interwoven Servlet Engine. The Interwoven Servlet Engine may be down, or running on an unexpected host or port.
If I refresh the screen, all's working OK. I can delete a few files, or a couple of directories, but a large deletion consistently errors out.
After checking out various logs, I noticed that the new content_center.log showed lots (and lots) of activity. I started watching this log while performing the deletions and saw that the deletion request was generating dozens and dozens (hundreds?) of jdbc connection requests and calls to the new back end database. I'm pretty convinced that it's this interaction that's causing the slowdown and eventual timeout.
It may be that we need to better optimize the connection to the db, but I'm suprised by the amount of communication to the db for what seems a fairly simple file deletion request.
Has anyone else run into this issue? On my 6.7.1 implentation, the response to this kind of request is snappy.
I've got a few other posts on DevNet about related db and performance issues with 7.1 (search forums for 'wally'), and this one seems particularly insidious. 7.x has introduced a new critical db component to the product set with little information on its function, administration, sizing, monitoring, etc. - and now it's also looking like a potential performance problem. Hmmmm...
Thanks for any insight here while I wait on Support to help with this -
Wally Box
Nike, Inc.
Find more posts tagged with
Comments
There are no comments yet