Rejane,
without going into details (I could not anyway) two attempts to answer your questions:
- the requests do not increase with number of results: This is good Database behaviour. The time to find the results does not grow linear with number of results or number of documents in the database. Good indexing is the reason here.
- second request is faster: Caching. The Database caches index and data used in previous queries. Second querie uses cache (memory) instead of Hard disk. Much faster. To get usable results for your test use some repetitions for each query and use the average, even better to take out extreme results.
Hope this help,
Timm
(which tool are you using? MS WAS?
#API-Management#Tamino#webMethods