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

Hello Thomas,

The only possible solution for that many nodes is to use load on demand. There is no other option I am afraid.

Regards,
Albert
the Telerik team

thx for your reply.

Isn't there any possibility with ajax (eg. load a huge list) to show the first entry of the query fast and then load the rest?

regards
Thomas

Hello Thomas,

Yes, there is. It however requires server-side load on demand.

Greetings,
Albert
the Telerik team