This is a migrated thread and some comments may be shown as answers.

Performance Issue while interacting with Service.

7 Answers 37 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
kalyan gupta
Top achievements
Rank 1
kalyan gupta asked on 24 Aug 2010, 06:24 AM
Hi @

I am developing an application using SL 4, VS 2010, Also I am using Telerik Controls in my application.

Architecture of my application is as follows:

One Solution containing Service that will interact with Database.
Another Solution contains Presentation layer which we call it as Client.

In Client's ServiceReferences.ClientConfig file we give the endpoint address of Service so that Client can display the records that are retreived from database using Service.

Now, If the Service is returning less number of records say 100 with 10 columns, the page is loading in 2 to 3 seconds. But as the number of records are increasing the page is loading slowly.

One example: 6000 records with 10 columns -> 45 seconds.

In Service we are returning in the form of List.

I have run the query separetely it is getting executed in less than 2 seconds.

If the Service and Client are hosted ins ame machine then the performance is good (Records are displayed in less than 5 seconds) But if I access the Service over the network then it is taking large amount of time as mentioned in the above example.

Please let me know if I am following correct architecture.

This problem is not with Telerik controls but please help me with any suggestions regarding Service Client communication.

Thanks in advance
Kalyan Gupta B

7 Answers, 1 is accepted

Sort by
0
Vesko
Top achievements
Rank 2
answered on 24 Aug 2010, 09:42 AM
Hello Kalyan,

why not using a datapager? This way only a small chunk of data will be transferred from the server to the client.
You can check the DomainDataSource example of RadGridView for Silverlight.
It uses RadDataPager and you can see that only 10 records are loaded each time.

Hope this helps.
0
kalyan gupta
Top achievements
Rank 1
answered on 24 Aug 2010, 09:48 AM
Hi

I am already using RadDataPager, I have observed that for the first time it fetches all the 6000 records but displays only 10 records.
When we click on next then it displays fastly.
But to display thge first 10 records it takes similar time 45 seconds for the first time.
0
Vesko
Top achievements
Rank 2
answered on 24 Aug 2010, 09:53 AM
It does not sound right. It should fetch only the needed items first.
If you check the online demo and open FireBug or Fiddler you will see that the first request is

http://demos.telerik.com/silverlight/Examples/Examples-Web-NorthwindDomainService.svc/binary/GetCustomers?$take=10&$includeTotalCount=

which takes only the first 10 items. Please recheck your configuration.
0
kalyan gupta
Top achievements
Rank 1
answered on 24 Aug 2010, 10:07 AM
I am unable to access the link which you have provided.

Could you please give the link again.
0
Milan
Telerik team
answered on 24 Aug 2010, 10:08 AM
Hello Sean Corny,

RadGridView will only download the shown data if you are using Ria Services. In case you are using a custom web service you will have to write some custom code to make it work as demonstrated in this blog post


Sincerely yours,
Milan
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
kalyan gupta
Top achievements
Rank 1
answered on 24 Aug 2010, 11:19 AM
Hi

I have been using Normal WCF service so far.

Now I am using Silverlight Enabled WCF service and seen significant improvement in performance.

But now also 6000 records with 10 columns is taking aproximately 25 seconds.

Please suggest me a better architecture to gain over performance.

Thanks in advance.
0
Milan
Telerik team
answered on 24 Aug 2010, 12:54 PM
Hi kalyan gupta,

Here is sample project that uses RadGridView + RadDataPager + Ria Services where the data gets loaded in a blink of an eye. 


Kind regards,
Milan
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
General Discussions
Asked by
kalyan gupta
Top achievements
Rank 1
Answers by
Vesko
Top achievements
Rank 2
kalyan gupta
Top achievements
Rank 1
Milan
Telerik team
Share this question
or