Server Application Unavailable -Access huge data

Question

hi This is kavita. I am accessing huge amount of data) aroun 4 lakh).my code is: Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cnOLE As OleDbConnection Dim ds As DataSet = New DataSet Dim daole As OleDbDataAdapter cnOLE = New OleDbConnection('Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=C:\DATABASE.mdb;Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False') cnOLE.Open() daole = New OleDbDataAdapter('SELECT * FROM tender_detail', cnOLE) daole.Fill(ds) DataGrid1.DataSource = ds DataGrid1.DataBind() End Sub but it give this ERROR--> Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the 'Refresh' button in your web browser to retry your request. I have change machine.config element responseDeadlockInterval like this and <httpRuntime executionTimeout='100' to <httpRuntime executionTimeout='1000' but still problem exist. can anybody help me?

kavita · Answer

Thanks to write to me, but problem still exist.is it not risky to modify machine.config? is there any alternative method to do so like in web.config or somewhere else?

Mahesh Chand · Answer

First of all, there is no need to get all 400,000 records at once. There is no way you can see all these records at once. You may want to use paging and get couple of thousand rows at once. Getting next batch of data can be implemented in a transparent way so user don't have to press next button. Your application should know when the cursor/view area is on the last record/batch and make another request to the database server to get next batch. Your application (database connection) may be timing out due to the data you are fetching. You may want to look at the connection timeout in connection string and database server as well. However, first point is necessary to fix this problem.

Server Application Unavailable -Access huge data

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)