Hi,
I first time faced with XMLForms of KM at a client project and the client experiences serious problems in terms of performance. I wonder whether somebody has successfully implemented a similar case or anybody may give practical suggestions/ideas/advice how to investigate the problem.
Here is the system:
EP60 SP2 Patch 3 Hotfix 7 and CM Patch 3 Hotfix 4. HPUX11, 750Mh, 3Gb memory, HP JDK1.3.1_13, Oracle 9i.
1. There is a DB based CM repository with AutoVersioning, Preserve Version Histories and Internal Links Default To Dynamic are all turned ON.
2. The repository has 15 services:
accessstatistic
comment
discussion
feedback
layout
personalnote
properties
rating
statemngt
subscription
svc_acl
Tbp
3. The repository has caches tuned according to the recommendation (from How to tune KM caches).
4. Filters. I don't know how to get a list of all fliters applied to the repository but I was browsing one by one filter and found that the following filters applied to the repository:
Kmfaqs
Kmnews
Xmlforms_filter
Besides that there are other filters applied to the repository but they're not active.
5. I browsed the repository directrly and saw for some documents 100 root versions and inside other tens of subversions though the original documents/folders are not in such a huge range (I mean without their versioned clones).
That's the description. Now the problem. All documents are pretty small (3-10Kb). We have a load test and if for one user to get a page takes 5 seconds for "loadtest" with 25(!) users it takes 20-30 seconds. I don't see any custom developed code in the process of getting those pages involved and all known recommendation have already been applied. I thought about creating another repository withouth XSL transformation put there transformed pages (in HTML form already) and run the script again but what can it lead me to? That our KM's XSL transformation doesn't cope with 25 users? Hardly believable. I suspect as a candidate also XSLs themselves. Probably there is a way to optimize it if they're build by XML Form Builder but this idea also doen'st impress me much.
Does anybody have experience with such a problem?
Any ideas I may test or pointing to materials to learn are extremely wellcome. The matter is top urgent.
Many thanks in advance,
Roman
Add a comment