Using WCF to fetch data from server

vikas_nm
vikas_nm used Ask the Experts™
on
Hi Experts,
We have got a client application that purely fetches data from the SQL server hosted in MS datacenter using dataset. The query generated is dynamic and not a static query which depends upon client selection.
The data fetched from the SQL Server is vey huge about 10,000 -20,000 records. We have optimized the SQL Server from a professional DBA and it takes 10-11 secs which is quiet acceptable by our client.
 
My question is should i created a WCF Services which will fetch the data from the SQL Server. Will this reduced the time to fetch data from the dataserver and increase performance of my application.

If so can you help with the code in building a service which will perform the task of getting data from the server as dataset.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
I would think that this would INCREASE the fetching time. The reason is that you will be adding a middle layer between the SQL Server and your application.

Author

Commented:
if i compress the dataset on the transfer would that reduce fectching time.
Most Valuable Expert 2012
Top Expert 2014

Commented:
Probably. That can only be determined by doing it. Can you not page the data?
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Author

Commented:
no i cannot page data as it is financial application and all values are needed for comparision. I will try to compress the data.

Can you suggest me a site for building the WCF Service for dataset.
Most Valuable Expert 2012
Top Expert 2014
Commented:

Author

Commented:
none

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial