Avatar of vikas_nm
vikas_nm
Flag for India asked on

Using WCF to fetch data from server

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.
WCFVisual Basic.NET

Avatar of undefined
Last Comment
vikas_nm

8/22/2022 - Mon
Nasir Razzaq

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.
vikas_nm

ASKER
if i compress the dataset on the transfer would that reduce fectching time.
Nasir Razzaq

Probably. That can only be determined by doing it. Can you not page the data?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
vikas_nm

ASKER
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.
ASKER CERTIFIED SOLUTION
Nasir Razzaq

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
vikas_nm

ASKER
none