For large databases, this means passing some hundred tables including their field structure and sort orders. When using relations, tables could even appear multiple times in the structure, as base tables or 1:1 related tables. You quickly end up with literally millions of API calls and thousands of database queries. While we paid a visit to treeview performance before, this was merely a cure for the symptoms. The start up speed of the Designer was still way slower than desirable.
With LL23, we finally are able to implement a feature we've been thinking of for quite a long while – delay loaded data for the Designer. This feature works for all implementations that use a data provider, i.e. for .NET and C++ applications. To give you some numbers I used the Adventure Works SQL Server demo database as a reference. This is what I got on my workstation:
Measured Variable
LL22
LL23
Process Memory
67,5 MB
41,8 MB
Number of DB Queries
630
2
Time for Opening the Designer
5,7 s
0,9 s
Jochen Bartlau leads the development at combit as Managing Director. He's a Microsoft .NET enthusiast driving innovation & agile project management. The mobile devices geek who used to be a physicist in his first life loves to spend his spare time with his family.