Skip to Content
0

ADS Data Dictionary performance issues

Jan 18, 2017 at 10:15 AM

221

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Joachim Höhne Jan 19, 2017 at 08:12 AM
0

Using a DD makes no difference in performance. But encryption is expensive, it slows everything down.

Share
10 |10000 characters needed characters left characters exceeded
Thomas Hens Jan 24, 2017 at 03:11 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Joachim Höhne Jan 24, 2017 at 06:52 PM
0

I think its try&error, as this depends on your type of database actions, e.g. whether you do ISAM style table navigating or sql style complex queries with multiple joins etc.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I also recommend looking in forums other than this community, e.g. stack overflow. If you're german speaking, maybe the "inoffizielles deutsches Xbase-Forum" is suitable, as they have a ADS sub forum. As it seems you're using Delphi, I strongly recommend the "Delphi Praxis". In both forums the well-known "ADS Guru" Joachim Dürr is more or less active (but definitively more active than here).

0