We have a problem with loading data from a query about 4000 elements. The query takes about 12 seconds.
In the query the editor of the sql server 2008 management studio the first rows comes immediately, then the rest are loading in the 12 secs.
In our RadTree we bound a tableAdapter. The query loads all elements first and then loads the elements to the tree.
The whole procedure from loading to showing the data to the user takes about 40 secs.
We want to get the usability from the query editor of the sql server. That means we want to show the first rows (root elements and nodes below) immediately to the user.
Load on demand is not an option for the application because of other functions.
Thanks for your help
Best Regards
Thomas
In the query the editor of the sql server 2008 management studio the first rows comes immediately, then the rest are loading in the 12 secs.
In our RadTree we bound a tableAdapter. The query loads all elements first and then loads the elements to the tree.
The whole procedure from loading to showing the data to the user takes about 40 secs.
We want to get the usability from the query editor of the sql server. That means we want to show the first rows (root elements and nodes below) immediately to the user.
Load on demand is not an option for the application because of other functions.
Thanks for your help
Best Regards
Thomas