Forum Discussion
HimanshuTayal
Community Hero
Coder : The URL which you are hitting is private or public?
If it is public could you please provide it to me so that i can try at my end and will let you know if i found something helpful?
richie
4 years agoCommunity Hero
Hey Coder,
You say your request returns "null", but can you explain what that actually means?
When you check taskmanager, does the vm resource usage just continue to increase without plateauing?
Is there a way to filter the retrieved recordset so you only fetch a certain number of rows? The reason im asking this is that an exposed api that allows the user to retrieve 60k records is not really helpful to the user, so id expect perhaps a query parameter enabling you to filter the query to be avialable....or at least this is what ive found before now.
When you submit the request do you get any sort of response (http response code) or does it just hang and never finish?
Most testing tools are gonna struggle to retrieve 60k records cos unless theyve been opyimised to handle this number of records, the whole 60k recordset needs to be loaded into memory to enable it to display it.
If youre not getting a response at all and the request for the 60k records doesnt complete, id be interested in viewing the logging of your http/application server cos the problem could actually be at that end and NOT at the ReadyAPI!/SoapUI end. From your current description im starting to suspect the issue is the app server.
Ta
Rich
You say your request returns "null", but can you explain what that actually means?
When you check taskmanager, does the vm resource usage just continue to increase without plateauing?
Is there a way to filter the retrieved recordset so you only fetch a certain number of rows? The reason im asking this is that an exposed api that allows the user to retrieve 60k records is not really helpful to the user, so id expect perhaps a query parameter enabling you to filter the query to be avialable....or at least this is what ive found before now.
When you submit the request do you get any sort of response (http response code) or does it just hang and never finish?
Most testing tools are gonna struggle to retrieve 60k records cos unless theyve been opyimised to handle this number of records, the whole 60k recordset needs to be loaded into memory to enable it to display it.
If youre not getting a response at all and the request for the 60k records doesnt complete, id be interested in viewing the logging of your http/application server cos the problem could actually be at that end and NOT at the ReadyAPI!/SoapUI end. From your current description im starting to suspect the issue is the app server.
Ta
Rich
Related Content
Recent Discussions
- 7 hours agoruchisingh