Lotus Notessql 206 Driver Top Page

When you first connect to an unknown NSF file, using SELECT TOP 10 * allows you to inspect the column names (items) and data types without overwhelming the system.

With optimal settings (batch size 500, indexed views, no rich text), NotesSQL 2.06 achieves 890-950 rows/sec on a single CPU Domino 7 server – roughly 1/20th of a native PostgreSQL instance, but adequate for sub-500,000 document databases. lotus notessql 206 driver top