Getting latest data
Posted on 2004-09-15
I need to generate a report containing latest data. Data is put into an Excel spreadsheet.
Database is medium-sized, approx 700 MB currently. About 50 forms and 100 views. It is for web but maintainance people do use Notes client.
I create a view that contains all the data I need (simple view, based on on form and a simple selection criteria). The view selects 7500 documents let us say. What will be the best approach?
Do I scroll thru using GetFirstDocument/GetNextDocument? Or should I use NotesViewEntry.Document? Its a flat view, no response documents, no totals, nothing. Please bear in mind that concurrency of data is important. Equally important is performance. This will be done many times a day, so more optimized the code the better it will be.
What is your opinion?