Our config module currently has only 8600 records and yet to get a dump of all the records via web services it takes well over 10 minutes. From our testing across our environments it is taking about 7-8 records per second. We find this stat to hold true even when we limit the query to only pull back a subset of CIs (such as of a certain type). Response time was significantly better under SC 6.2.
Server OS: Win 2003
RDBMS: Oracle 10g
Does HP have any general guidelines/benchmarking on what is "normal" wait time for a web services request/response?
Our Development staff is working on this issue under QCR52548.
1. Add the following parm to your sm.ini file: dbcachequery:extaccess
2. Recycle ServiceManager
3. Test your webservices scenarios.
What the parm does is it caches any query that is run against the file specified.