Jump to content
  • 0

Web Service: System.OutOfMemoryException


hhelsky
 Share

Question

Greetings!

I'm trying to fetch a rather large dataset/view out of Caspio with 95000+ rows and up to 16 fields. Unfortunately the Web service returns a System.OutOfMemoryException when the request consists of over 7 fields.

"{Internal error. Exception of type 'System.OutOfMemoryException' was thrown.}"

Any suggestions how to go around this unfortunate situation?

Came to my mind at first, to do a single request to retrieve unique ID's of all the rows, and then perform multiple requests to fetch all needed data based on these ID's. Have not tested it yet, but seems like the only alternative.

What would be the preferred way to fetch large datasets from Caspio's WS in the case of memory running out?

Best regards...

Henryk

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi Henry,

You have posted the Bridge related question in Express DB forum, in the future please post your Caspio Bridge questions under Caspio Bridge forum viewforum.php?f=3

To answer your question, Caspio Bridge APIs are available mainly for purposes of manipulating records through an external system. They do have some limitations on numbers of records that can be extracted in one call. However, they provide the ability to specify on the “where clause” criteria that will allow you to extract large amount of records with looping on the application side. It all depends on the purpose of the program.

For example, if you have a table with one million records and you need to extract all of them, then you can loop through the API call 20 times and extract 50,000 records at a time. You can combine/store them to the appropriate structure on the application side.

Hope this helps.

Best,

Bahar M.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...