asmx webservice return limit number of records from database

Question

User-506497988 posted
Hi everyone i am new in webservices we have big project
Between 4 entites and we are one of them
We share our data view from oracle database
I created asmx using vs2017 and test it in soapui
And working fine but if in production the view contains 1 million records it return nothing and also the i used database authentication to access the service is it the rights way please help
Thanks

Answer 1

User-943250815 posted

And working fine but if in production the view contains 1 million records it return nothing

Looks a lot of records. Did you checked how much time takes to have all records ready to be transmmited to the client?
IMHO you are having a timeout on client side, so when records are ready, client already disconnected.
Of course you can set timeout on client, but I suggest you try to reduce number of records needed, if you can.

Answer 2

User-506497988 posted
The records coming from oracle database view first i test using 49 records and it working fine the response within seconds when i tested it on production which has big number of records it is take seconds and return nothing i am asking it fine when recordsless than 49 records

Answer 3

User-943250815 posted

I´m just telling that for sure there is a technical limit, it can be size or time when there is a huge data to be returned, due to nature of http protocol.
As I understand as soon result data grows you are getting no response.
I already had a similar issue consuming webservices, in my case there was no error, webservice just returned "Nothing". I have no answer for this since webservice was not managed by me.

But in your case, I´m talking about "large data" if may help bellow some threads with similar issue
https://forums.asp.net/t/1369287.aspx?How+to+get+very+huge+number+of+records+of+data+through+webservice+
https://forums.asp.net/t/1479646.aspx?Passing+Large+dataset+through+WCF+service
https://forums.asp.net/t/1601804.aspx?Ajax+issue+delay+in+getting+data+from+web+service+using+innerHTML+please+guide