[Solved] Silverlight/WCF-RIA performance

[Jakkie Esschert van den]

Hi,

I've done a quick test with the RIA support in Telerik Open Access, largely based on this blog post. Since we are evaluating this for an app which deal with more then just a view records I did some tests with 3000 records in the employee table and binding that to a RadGrid in the silverlight app. Even when running everything locally that performed, to use a proper understatement, less then impressive. Which made me worry whether this is going to be at all usable on an internet link. 

This is the very first stuff I've ever done with WCF-RIA services at all, so I might be missing obvious things and I'm also not entirely sure what should be blamed on WCF-RIA and what on OpenAccess, it might be all Microsofts fault...

Is anybody here actually using this stuff, and if so, how do you manage to keep the performance at a bearable level? Is it at all wise to use WCF-RIA for anything bigger than grandma's birthday calender?

I also noticed the OpenAccess Silverlight Integration Demo seems to suffer the same problems. On my home connection (20/1mbit, and I really reach those speeds), it takes around 12 seconds from the moment the grid appears till the moment it's populated with data. That grid contains 793 rows, each containing at most 300 bytes of data. A quick check with a network sniffer reveals that over 3MB of data is transfered to populate the grid. Surely there must be ways to reduce that drastically?

[PetarP]

Hello Jakkie Esschert van den,

 The performance pretty much depends on the amount of information you require for your specific scenario. Are you aware of our Fetch plan API that allows you to greatly reduce the number of query and the information being retrieved from your sql server? I suggest you have a look at the following help article.

Regards,
Petar
the Telerik team