Web Service size limitations...please help!
I have a webservice which connects to the db and fetches the data for the given input.
The resultset is traversed and converted to a list of objects, this list is sent back to the requestor.
Now for a particular query which returns a large chunk of data say 73000 records, I get a "out of memory" error.
Assuming that each records will be of 1kb , our result set will be of 71mb approx. Now when we traverse the RS and make a list out of it, I assume the total size of the class object to reach 3 times the size of the RS i.e 213mb.
I have 3 solutions to solve this problem, but none of these is the best solution I can think of.
1. Paginating the data, not possible as this is a web service and we cant have a delimiter as an input to the service.
2. Increasing the JVM size, can be increased to max 1GB, but this will fail in the scenario where there are multiple hits. (Short term solution)
3. Release the RS objects once they are added to the list, this would bring down the size of the class object to 142 mb max.
Is there any other solution to this problem?
Is there a upper limit to the size of data that can be sent through an Webservice?
Last edited by panache; 03-01-2007 at 03:49 AM.
Reason: spell error
Last Post: 04-18-2007, 02:34 AM
Last Post: 02-28-2007, 04:04 AM
By xsouldeath in forum Java
Last Post: 12-10-2005, 10:56 PM
Last Post: 03-07-2002, 06:38 PM
By Tim in forum Enterprise
Last Post: 03-05-2002, 03:44 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL