which control is more faster repeater , data grid view, response.write etc
-
Hello all, I am searching for control which control is more faster to display data from database. currently I am using repeater control and data grid view. and some time I get data with help SqlCommand and Sql addapter I though it is more fast. If I create a custom control and use response.Write it will fast? If you have any suggestion than please share with me. Regards
-
Hello all, I am searching for control which control is more faster to display data from database. currently I am using repeater control and data grid view. and some time I get data with help SqlCommand and Sql addapter I though it is more fast. If I create a custom control and use response.Write it will fast? If you have any suggestion than please share with me. Regards
Data Adapters are slow, databinding is slow, data binding using DataBinder.Eval is really slow. Get the data via a Data Reader, stuff it into a custom object, and then render the page using a repeater control without using DataBinder.Eval and I think you will notice a fair, maintainable improvement. Also, how much data are you trying to display? Retrieve the smallest amount possible for the given screen and rendering only the required elements is another avenue for speed improvements.
Need custom software developed? I do C# development and consulting all over the United States. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane
-
Hello all, I am searching for control which control is more faster to display data from database. currently I am using repeater control and data grid view. and some time I get data with help SqlCommand and Sql addapter I though it is more fast. If I create a custom control and use response.Write it will fast? If you have any suggestion than please share with me. Regards
Your main bottleneck will probably not be the repeater, response.write or gridview. If you can, cache the data. I wrote an article with an easy way to do that http://www.codeproject.com/KB/aspnet/LookUpDataCache.aspx[^] You main bottleneck will probably be the SQL query, not the serialization of the data. Also, if you use the repeater or gridview's itemdatabound event that will be faster than setting the data in the mark up. Because the mark up has to use reflection to get the data type.
I didn't get any requirements for the signature