Web Service size limitations...please help!


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: Web Service size limitations...please help!

Threaded View

  1. #1
    Join Date
    Feb 2007
    Posts
    2

    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 04:49 AM. Reason: spell error

Similar Threads

  1. Replies: 2
    Last Post: 04-18-2007, 03:34 AM
  2. Web Service size limitiations
    By panache in forum Web
    Replies: 0
    Last Post: 02-28-2007, 05:04 AM
  3. queues how to print it
    By xsouldeath in forum Java
    Replies: 0
    Last Post: 12-10-2005, 11:56 PM
  4. UserData Size Limitations
    By Amit in forum Web
    Replies: 0
    Last Post: 03-07-2002, 07:38 PM
  5. Exchange DB size limitations
    By Tim in forum Enterprise
    Replies: 1
    Last Post: 03-05-2002, 04:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center