Complex table structures with a lot 1:n relations are loaded slow in the designer

Idea Place
1

If you have a complex table structure with a lot of 1:n relations LL reads already known tables again and again.



Example:

Table A 1:n relation to Table C

Table C 1:n relation to Table C

Table A 1:n relation to Table D



For each relation LL uses IRow GetChildTable and GetParentRow to get the layout of columns to add to LL in the deisgner. In fact. The layout of table A never changes. So using GetParentRow again and again slows the system down.



Currently I used my own caching schema. But internally LL would be much faster in duplicating the already known columns into its list of fields.

2

This should be much faster now: https://www.combit.net/en/blog/development/07-2017/huge-designer-speed-up-for-large-databases/