Number of bytes an API_Doquery can return

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hi All,

I am handling an application which contain huge amount of data and the data will increase everyday.

So can you please help how much bytes the API_DoQuery can return so that I will handle it accordingly

Photo of Ananth

Ananth

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
I don't think there is a number published or quite frankly which parameters effect the download. What you might do it try an experiment to perform n downloads of increasingly larger size and see what the results are. I used this code from the console to make 18 requests for an increasingly larger set of records (+10 at a time - 10, 20, 30 ...) from the formula function table:

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=515

See attached screenshot.

Your parameters for n and size will be larger but you can just modify the script and run it. Note that this is one of the few instances where you would use a synchronous AJAX requests to avoid one AJAX request effecting the performance of other simultaneous AJAX requests.