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

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


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.

This should be much faster now: