hi!.
i am developing web appln in VS2005,using C#.
i have shown a nearly 2lakh rows in gridview on a page load event,i have textbox to filter the rows of data,
now am using the new query with the where condition,again making connection to database,then binding to the same gridview.
so it is taking muchtime since the large data,and need of opening/closing the database.
is there any that, can we search within the dataset,after that biding result set in to gridview.
or else what shall i do ,to improve the speed performance to handle the large amount of data.
|
| Author: Anil Kumar Pandey 26 Sep 2008 | Member Level: Diamond | Rating:  Points: 2 |
hi,
Better to INDEX the records in the data base,
Indexing will do the task much faster than with out INDEX.
Thanks
Anil
Thanks & Regards
Anil Kumar Pandey
|
| Author: vasanthiraajan 26 Sep 2008 | Member Level: Gold | Rating: Points: 2 |
hi,
You can use DataView instead of Dataset.
DataView is mainly used for Filtering and Searching purpose
Regards,
Vasanthi
|
| Author: Sidewinder2 26 Sep 2008 | Member Level: Gold | Rating: Points: 4 |
hi,
dataset are similar to sql tables. so why dont u search in the dataset (after making the query with out filtering and filling the result in the dataset )it self instead of searching in the database.
if i misunderstood ur problem please let me know.
cheers!,
Myself
|
| Author: VinC 26 Sep 2008 | Member Level: Silver | Rating: Points: 5 |
One more way is to retrieve only selected rows ...
I mean only 10 rows at a time for example
U can make a query to retrieve it so it will give u a good performance
:)
try that or u can also use Data view for making filter
but i think if u will handle it in sql then sql server will take care of that easily
try that or let me know :)
i had faced such problem and in that i had used such query to retrieve rows at single trip...
Try that :)
Thanks
Vinayak Chauhan
Thanks,
VinC
|
| Author: jayakumar 27 Sep 2008 | Member Level: Gold | Rating: Points: 3 |
hi Sidewinder2 ,
thanks.
thats correcet,i dont know how to search,or make query from the dataset itself,could you let me know, if anything regarding this.
|