Webtop performance issue

Dipesh_Chauhan

In our environment we are using, CS D6 SP1, Oracle DBMS 10.2.0.3, Oracle application server 10.1.3.2.0 & custom types.

We are having issues while entering the relevant attributes after importing a document in webtop.

We have more then 5 different dropdown attributes in the same attribute card fetching values from the oracle database (Conditional value assistance)

After selecting appropriate values for the 1st dropdown attribute its taking 30-40 secs to fetch the conditional values from DBMS  for other dependent text boxes & dropdown attribute values, so overall it takes 10-12 mins for a user to upload a document

Standalone environment (issue)

Location A: Application Server, DB
Location B: Content Server

Distributed environment (does not have this issue)
Location A: Database, App Server, Primary CS
Location B: Remote CS

In these cases locations are different but servers are same

Performance imprvmnt suggestions please

mszurap

Hi,

The most common bottleneck is the application server's JVM settings. How many heap memory does it have? I recommend at least 1 GB if no other web application is running in it. Of course other Garbage Collecting settings could be used, you can search it on the for them.

The conditional value assistance you are using is "static" (fixed list) or dynamic (using DQL query)? In the second case, you could create some indexes on the queried where clause attribute.