Use Command (or Control) + F on your browser to search this; all recipes are listed from this page.
Lotus Notessql - 206 Driver Top
Set CommitBatchSize=500 in the connection string. Above 2000, NSF page contention reduces gains.
| Notes Item Type | SQL Type (2.06) | Performance Penalty | |----------------|----------------|---------------------| | Text (single) | VARCHAR(255) | None | | Text (multi-value) | LONG VARCHAR | +15% | | Number | FLOAT | None | | DateTime | TIMESTAMP | +10% (timezone conversion) | | RichText | LONG VARCHAR (blob) | +300% if retrieved | lotus notessql 206 driver top