Web Forms :: SQL DataReader Takes Lot Of Time To Load Data
Nov 29, 2012
i am having the problem that i am using datareader to get contents in my asp.net page.But the page takes a lot of time to load.How to decrease the loading time of the apage and increase the performance of my page.
to search for specific word. It is very quick in finding the word, but when loading that amount of data to my dictionary it takes a while. Could you say what is the efficient way deal with such data? This is not homework or work related, but it is my personal project.
I am working on a ASP.NET 2.0 application. It is hosted on IIS 6 on Windows 2003 server.
Few pages have jpeg images (around 50 images and 50 KB each). It takes long time to load the page for the first time. But when i open the same page for the second or third time it is faster.
why does a web page take long time to load for the first time?
Is it cached somewhere when it loads for the first time? Do we have any control over it?
if I hit the .aspx page on the browser and if the page takes time to load say may be 25-30 seconds then what are the steps to be taken to make sure that the page loads quickly. In other words what could be the reason for this slow loading.
I've dynamically made an ImageButton, the problem is when I hover the Image, it takes a few seconds to load the hover image (imgHover.png in my code)..
Is there a way to preload the images or something?
Displaying loading gif image whenever my page takes time to load but not for particular single control. i had seen this. URL...but it working for button , can i check it for my whole page and all controls whenever it takes times to load.
I have developed a web application in .net & if the web application is idle for some time & after that if we perform some action on that web page then it doesn't respond.
What should be the approach while designing when you know that your page would take considerable time to load? e.g. if it has controls which are heavy & some which are lighter? Can we make use of any of the design patterns to solve this issue?
I have no problem when paging my FormView, the dropdownlist does not read the next record and keep the value of the first loaded record? All other textbox control behave normally and move from record to record excepted the ddl??Here the code.
Public Sub DoData() Dim myConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString) Dim myCommand As SqlCommand = New SqlCommand("SelectSupplier", myConn) myCommand.CommandText = "SelectSupplier"
I have selected around hundred data and then bind to the repeater each times it take a long time to save data after clicking the save button. How can i improve the performance?
I there I have recently created an ASP website wich uses .net 4 and SQL db but soem some reason even displaying 20 records in a gridview is slow... So after some reading I converted the website to a Web Application Project so its compile prior to publish.. But yet again this is a bit slow. pages loading time is not of a bit issue...
I am trying to create a progress bar for page load as it takes long to load. I need help to resolve jscript error 'null' is null or not an object on line $get("btn").click();
i have 4 dropdownlist controls in a page. each have more than 6000 records. when retrive the records from DB there is no issue and taking very less time. after getting the records it takes too much time to display in the the page. here no problem with db retriving.. i guess problem is with page weightage. how can i solve this problem..
when my website allow user many connectionstring by text to connect database anh retrieve data. But when user define very may wrong connectionstring. So Method in DAL dataset.Fill() takes a longtime to throw exception.So mywebsite will be die.
I want to method dataset.Fill() throws exception immediately when a connectionstring wrong. How can i do that?
I have a aspx page which contains 6 user controls which will be displayed when the user clicks on any button using show model pop up extender. My page rendering takes more time. it taked 3 minuits to load the page. If i debug the page its traveling to page load of all the user controls. Its not taking more time to fetch the data from database but its taking time to load the page. Is there any way to improve the perfomace .Is there any place where i have to look into.I am using VS 2010 and c# .
I am a PHP MYSQL person but now i have got webiste to do it ASP.net.I kow nothing about ASP.NET. INitially i was thinking of ASP.NET as a programming language but now i now its not , i really don't know what it is.Someone told me that i have to do c sharp to build the website. I i have to display simple data from database how much different is c sharp from php.Does it has all function like php to echo stuff etc
I have table for past four years. It had a records for around 10 Lacks it was taking lot of time to execute so i removed recordes from the table. Table size was reduced to 29 thousand. Still when i execute a query from my application it takes more than 2 minutes to return.
My asp.net web app uses a master page which contains an 8k jpg of the company logo. Whenever I load a page or do a refresh, all of the non-master page html renders first, then the master page logo is shown, pushing all the html down a few lines. It's very annoying. Is there anything I can do to prevent that from happening?
One of my web pages populates a droplist with about 60k items pulled from SQL Server, and this operation takes upwards of 10 seconds to complete. Are there some tricks or optimizations I can try to improve performance? I'm using a SqlDataSource configured as a DataReader.