Knowledge Base

KB10748 - Opening a .TTKLS file constructed on MDB (MSJET) is very slow and uses a lot of memory.

An MSJET database layer can be slow and consume a lot of memory if there is a lot of records. For better performance in such case, add to your .TTKLS file ENGINEOPTIONS=8, like in this example:

  [TatukGIS Layer]
  ADO=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=gistest.mdb

This will force server side cursor instead of client side cursor.

Created: March 07, 2007, Modified: March 06, 2013