Application Development Software

Hi All,
We have similar problem with our implementation. We have around 45000 + docs and we have written Custom Search API to search and publish the docs(Attribute & Context). Whenever we do context search on some common terms it just doesn't come back at all.When we do attribute search and search it takes lot of time (more than 10 mins). I guess it should come back in secs.
Details of our implementation :
1) Java Custom APIs written on top of IFS 9.0.1 API
2) Database and IFS are on same box
3) Database runs on multiple disks not on single disk
4) Front end (servlets & JSps) run on different server than where IFS is installed
5) Tomcat 3.X version
6) We are using Oracle 9i OCI jdbc to connnect from Application to IFS server

All of the searches are taking lot of time. We have gone over most of the discussion here and not getting what could be the problem
Intially the system was working fine but as Documents number increased , performance has degraded dramatically. Since we are using the system based on IFS from long time and management is deciding whether to go ahead with iFS as content management backend is really crucial for us.Please let us know how could we improve performance.

We are running Analyze script every 1 hour.We have included indexes for attributes of custom classes.


I'll really appreciate if someone gives some information regarding this.

Thanks
Rajesh Basawa
Cisco Systems.