Search code examples
databaselotus-noteslotus-dominolabview

Domino DB View.AllEntries takes ages

as the title says: I just want to get the first 10 entries of a Notes Domino DB like the SQL Statement "Limits" - foolishly using labview.

Therefore I create an IDatabase Object, accessing via GetView. This returns an IView Object and is valid. For getting an IViewEntryCollection, I have to run the AllEntries property but this takes ages... I thought I'd get just a pointer object which I can enumerate by ViewEntry.ColumnValues and ViewEntryCollection.GetNextEntry.

Is there an other method instead of using the View.AllEntries call? However, retrieving all database entries seems for me as a little overkill if I just want to have the first 10 entries.

Thanks a lot,

AllDayPiano

Solution

  • Once you have the view object you can create a ViewNavigator object. The view navigator has methods that let you iterate in order with GetFirst and GetNext methods.