When reading XML formated data from a view via a URL we are consistently only able to read the first 57,600, or 65,535 rows of data whether we attempt to access the view via an “openview” command or using “readviewentries”.
We are using Lotus Domino 8.5.1.
The initial URL command has the form “www.serverName.net/viewName?openview”
The view has one column of data formatted as XML. This view is wrapped in a root tag by having it embedded via a $$template field on a form.
We then tried opening the view directly using “www.serverName.net/viewName?readviewentries”. This returned the full DXL content of the view, as expected, but still only 57,600 rows.
We then increased all the limits in the web server configuration documents, such as default and max number of view rows to return from 1,000 to 100,000,000, or to 0 for those fields that when set to 0 are marked as “unlimited”.
We also changed the syntax to “www.serverName.net/viewName?openview&count=-1” which should mean “return all rows”.
This had the effect of now returning 65,535 rows. OK, this number at least looks like a binary power threshold imposed by a simple integer counter somewhere - who knows where the 57,600 was coming from.
A couple of notes:
-
We get the same number of rows returned regardless of the amount of data per row.
-
The data that is returned is valid, which is to say that we are getting full rows including our closing root tag,
and not having the data cut off in mid-row.
Does anyone know if this is a “hard” limit for the number of rows that “openview” and “readviewentries” will return?
Does anyone have an explanation for either of the 57,600 or 65,535 limits?
Any help as to how we can use this method to pull more than 65,535 rows of XML formatted data would be appreciated.