+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

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: https://www.combit.net/en/blog/development/07-2017/huge-designer-speed-up-for-large-databases/