how can we increase the perfrmance of dataset

Posted by Kummee under Regular Expressions on 4/21/2011 | Points: 10 | Views : 1649 | Status : [Member] | Replies : 3
Hi All,

This is about dataset. I want retrieve 1000 records from the database. these much records are retrieving the dataset performance will be slow. Why i am choosing dataset is i want modify some data in records.So I want increase the performance of dataset.
Any body help me...




Responses

Posted by: Vuyiswamb on: 4/21/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
1000 is not much if you wrote your query correct and if you have indexes on the unique fields in the database. If you are going to display this on the gridview, you must consider paging the grid. But 1000 should not be a problem.


Thank you for posting at Dotnetfunda
[Administrator]

Kummee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prabhakar on: 4/21/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hi Kummee



say ur full requirement . . i think data set is best way to fetch record . .

Best Regard's
Prabhakar

Kummee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kummee on: 4/21/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Thanks for giving suggestion

Myrequirement is dataset is disconnected architecture.because the server perfromance will be slow.i want dicrease the load on server.

Kummee, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response