Search is slow if large data in Gridview
-
If there is large volume of data in Gridview. and no paging in Gridview. If i click the search button to search the text then the search is slow.
Mahendra
sumB wrote:
If there is large volume of data in Gridview. and no paging in Gridview
If 'No Paging', then what else do you expect in case of large volume of data? When there is no pagination, whole data is wired and rendered on the webpage - it will be slow. Accept it or paginate it.
Sandeep Mewara [My last article]: Server side Delimiters in ASP.NET[^]
-
sumB wrote:
If there is large volume of data in Gridview. and no paging in Gridview
If 'No Paging', then what else do you expect in case of large volume of data? When there is no pagination, whole data is wired and rendered on the webpage - it will be slow. Accept it or paginate it.
Sandeep Mewara [My last article]: Server side Delimiters in ASP.NET[^]
Thanks for the Reply, You are right. I have client requirement that, I can have only vertical scrollbar. I am not worried about the slow page listing. But i am concerned when i search a single record from database and bind a single row to the grid. then the page took a long time to accept the post request. I have a textbox for search text and dropdownbox for search criteria. so when i click on Search button, The page took a long time to accept the post request.
Mahendra
-
Thanks for the Reply, You are right. I have client requirement that, I can have only vertical scrollbar. I am not worried about the slow page listing. But i am concerned when i search a single record from database and bind a single row to the grid. then the page took a long time to accept the post request. I have a textbox for search text and dropdownbox for search criteria. so when i click on Search button, The page took a long time to accept the post request.
Mahendra
You cannot do much here. Tune your query and DB to have quick response as much possible. UI wise, max you can do is show 'Processing...' or 'Loading...' text or icon until grid is not shown.
Sandeep Mewara [My last article]: Server side Delimiters in ASP.NET[^]
-
You cannot do much here. Tune your query and DB to have quick response as much possible. UI wise, max you can do is show 'Processing...' or 'Loading...' text or icon until grid is not shown.
Sandeep Mewara [My last article]: Server side Delimiters in ASP.NET[^]
-
Actually I have My gridview and search button inside UpdatePanel. so on search button click UpdatePanel took a long time.
Mahendra
Simply use
Update Progressto show a progress to details update of Update panel. Present it to the client as maximum possible based on requirement.Sandeep Mewara [My last article]: Server side Delimiters in ASP.NET[^]
-
Simply use
Update Progressto show a progress to details update of Update panel. Present it to the client as maximum possible based on requirement.Sandeep Mewara [My last article]: Server side Delimiters in ASP.NET[^]
-
Thanks for the Reply, You are right. I have client requirement that, I can have only vertical scrollbar. I am not worried about the slow page listing. But i am concerned when i search a single record from database and bind a single row to the grid. then the page took a long time to accept the post request. I have a textbox for search text and dropdownbox for search criteria. so when i click on Search button, The page took a long time to accept the post request.
Mahendra
sumB wrote:
But i am concerned when i search a single record from database and bind a single row to the grid.
This is the query problem. Nothing to do with update panel,page or Gridview. Run the query using profiler so that you can come to know how much time it is taking to execute and where you can fix the problem.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
-
sumB wrote:
If there is large volume of data in Gridview. and no paging in Gridview
If 'No Paging', then what else do you expect in case of large volume of data? When there is no pagination, whole data is wired and rendered on the webpage - it will be slow. Accept it or paginate it.
Sandeep Mewara [My last article]: Server side Delimiters in ASP.NET[^]