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.