ADS Data Dictionary performance issues

[#1]

We recently updated our program to use Data Dictionary bound tables instead of free tables. But it seems like our program got a lot slower in Data Dictionary mode than in Free Table mode. Is this because of the encryption added to the Data Dictionary files, or are Data Dictionaries just a lot slower?

[Former Member]

I tried disabling encryption and it helped to improve the performance a little.

The AdsSettings we had before Data Dictionary are :

_ADSSettings.NumCachedCursors := 127;
_ADSSettings.NumCachedTables := 127;
_ADSSettings.ShowDeleted := false;

But since we use .adt tables and not DBF I guess ShowDeleted is no longer usefull?
Are there optimal settings for NumCachedCursors / NumCachedTables or is it just trial and error?