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]
  Storage=Native
  LAYER=lwaters
  DIALECT=MSJET
  ADO=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=gistest.mdb
  ENGINEOPTIONS=8


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

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