CODEWITHSUNDEEP
wcf
user679530
user679530

Reputation: 917

Optimize WCF CAll

I have a database call which gives me 40 columns and 75000 rows, I am using a WCF service to get the data to client , my method returns this object to the client and after getting the data and into an object to send to the front end it takes atleast 5 secs. How can I optomize this.

Upvotes: 0

Views: 158

Answers (1)

Shiraz Bhaiji
Shiraz Bhaiji

Reputation: 65391

It sounds like you are downloading the entire database to the client.

The best optimisation would then be to only download information to the client that you really need to download, and do not download it until it is required.

  • A person is not going to browse 75000 records. Even if they did you could use paging.
  • If the client is using this data to do calculations, then these calculations should be done on the server.

Upvotes: 1

Related Questions