lynnadams
asked on
Performance issues with Web application vs. Windows Application using Web Services
I am comparing 2 similar applications, one is a windows application using web services the other is a web application. When reading a master file that contains 10,000 records the Web application is 100x faster. Instead of trying to push all 10,000 records through a web service is there a good way to do "Paging" via a web service???
ASKER
The master file is just a SQL database table that contains about 10,000 records.
The web application takes all of the records and places them in a web data grid with paging uisng a select all into a dataset then binding the data set to the web grid.
The windows app uses a web service to do a select all into a data set, passes the dataset back to the windows app and then a databind is used to attach the dataset to a windows datagrid. Because the dataset is so big it take upto 3 minutes to return the full dataset
The web application takes all of the records and places them in a web data grid with paging uisng a select all into a dataset then binding the data set to the web grid.
The windows app uses a web service to do a select all into a data set, passes the dataset back to the windows app and then a databind is used to attach the dataset to a windows datagrid. Because the dataset is so big it take upto 3 minutes to return the full dataset
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jack