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:
This will force server side cursor instead of client side cursor.
Created: March 07, 2007, Modified: March 06, 2013