How To Handle Large Volume Of Data In Gridview
Mar 19, 2010I have large volume of records in my database(70k).How do i handle with this kind of volume data in gridview. Is there any samples provided for this?
View 2 RepliesI have large volume of records in my database(70k).How do i handle with this kind of volume data in gridview. Is there any samples provided for this?
View 2 RepliesI have a standard ASMX web service which uses a lock object to process the first request it receives and reject other requests that come in before processing completes. The web service is hosted on a Windows Server 2003 box with a single-core processor. To test whether this works as expected, I wrote a client that spawns 100 threads. Each thread makes an asynchronous POST call to the web server (i.e., HttpWebRequest.BeginGetResponse()). From my own logging, what I'm seeing on IIS is that two threads are spawned. Let's say thread IDs 1 and 7. Thread 1 is assigned a small number of requests. It accepts and processes them, one after another. Thread 7 is assigned a large number of requests. It rejects them. Does anyone have theories on the following: Why are two threads spawned? And not four or a hundred? Why does there seem to be thread discrimination? Thread 1 looks like it has control of the lock object at all times.
View 1 RepliesHow Does IIS Handle a Large Volume of Requests
View 2 RepliesI'm creating a web page that will show a form that allows a user to query a database and then page backwards and forwards through the data. In other words one record of the returned data will be displayed on the form and the user can move forward to display the next record or back to display the previous one.
My problem is that a large volume of data may be returned and I'm wondering the best way to keep this data between postbacks. I would think there would be too much data to use viewstate.
I'm developing a web app for which the client wants us to query their data as little as possible. The data will be coming from a Microsoft CRM instance.
So we've agreed that data will only be queried as and when it is needed, therefore if a web user wants to see a list of contacts (for example) that list is fetched into a local DataTable. Then if a new contact is created on the website the new contact is sent to CRM and added to the local DataTable at the same time. Likewise for edits.
If the user then looks at their contacts again the data will just come from the local DataTable.
In my database when I fire query it takes 40 secs on 1 crore data, similar when I use join with other table then it take more time. I have taken care non cluster index such thing. But still I want to optimize my query, what other thing I need to take like buffer, disk size etc. I am not sure on this area.
View 11 RepliesI'm having an issue sending large volumes of emails out from an ASP.Net application. I won't post the code, but instead explain what's going on. The code should send emails to 4000 recipients but seems to stall at 385/387.
The code creates the content for the email in a string.
It then selects a list of email address to send to.
Looping through the data via a datareader it picks out the email address and sends an email.
The email sending is done by a separate method which can handle failures and returns it's outcome.
As each record is sent I produce an XML node in an XML document to log each specific attempt to send.
The loop seems to end prematurely and the XML document is saved to disk.
Now I know the code works. I have run it locally using the same SMTP machine and it worked fine with 500 records. Granted there was less content, but I can't see how that would make any difference.
I don't think the page itself times out, but even if it did, I was sure .Net would continue processing the page, even if the user saw a page time out error.
I'm testing a very simple aspx page on Visual Studio's own ASP.NET Development Server(the local server). On the webpage there is a FileUpload control which can upload jpg file up to 2MB without problems. On uploading bigger files, the browser immidiately show "The web page cannot be displayed". It does not show any exception which really puzzles me. "The web page cannot be displayed" is normally caused by network problem, but in this case it's a local server and it can handle smaller jpg file fine. Whta's the problem here?
View 3 RepliesI am trying to show a large amount of data in gridview but the problem is that everytime data increase the gridview row size increase automatically.
is there any possible way that the data which is stored in my MS access Database display in multi line instead of one single long line.
I have a gridview that is currently showing 20 lines per page. Each line has several fields in it, three of which are dropdownlists. These dropdownlists are populated with a SQLDataSource and then the selected value is bound to one of the gridview datalements.
The problem I'm running into is that the page is very slow to load. I believe this is because of the large dropdownlists (and possibly because there are roughly 60 of them, each of which is executing a SQL query to populate the list of available values). The file size that is being transmitted over the web is just over 1.25MB in size, again from the large amounts of data in the dropdownlists.
Is anyone aware of a technique by which I could only execute the query from the SQLDataSources that populate the dropdownlists' available values once and then reuse the results of that query to populate the relevant dropdowns? Ideally I would do this on the client side so it would also limit the amount of text being transmitted to the client browser.
I have 65 columns in the grid, if the columns are reduced to 20 then the speed when accessing from client is more or less similar to that accessing from web browser. Does it mean that all this performance issue is due to the data only ???
View 1 Replieshow to display large amount of data in griedview with serach funcationality.(the data should be 20 L)with example in asp.net.
View 1 RepliesI want to bind large amount of data in gridview using jquery but without paging.
I am taking reference from this post
[URL]
But when there is large amount of data, it's not working
when i did not have too many controls on the gridview, it was displaying fine. but when i added more controls, it has become very slow and displays a large size for a second or so, and then comes to normal size.
View 1 RepliesASP.NET 3.5,I'm upgrading a page that currently uses classic asp and xslt to display about 2000 readonly tabular records. Please leave aside the issue of whether this is a good idea or not.My asp.net replacement page uses a gridview to do the same thing.The scrolling in IE8 using this old code is very smooth and even. The scrolling using the asp.net page is horribly jerky. I can't figure out why - there doesn't appear to be much client side code running.Any clues welcome as this is a high traffic page that I want to look as good as possible.The same page also can't handle a row highlighter - same reason slow and jerky.
View 2 RepliesIn my database m having 1000 record and I want to display 10 record on each page on gridview so every time it fetch 1000 record so while page loading it is quite time consuming ..
View 1 RepliesI have a very large text file whose data I need to extract and display in a gridview control. The method I'm using now is as follow:
1. Read each line of the textfile using StreamReader, into a String.
2. Split the String and populate the fields of a detail object.
3. Add the detail object to a List.
4. Repeat steps 1 to 3 for each row of the text file.
5. Bind the list to the gridview.
I think most of the time is spent processing the text file data (steps 1, 2 & 3).
Is there any way this can be done quicker and more efficiently? At present, it takes ages to read and process a 76 mb text file.
I have one gridview with two columns.. I am fetching data which is like invno, invno, invno, invno, invno, invno, invno, invno,.......... in one column.. but problem is when ifetch more data its Growing Across Gridview and Table.. i used following code
<td align="left" width="100%">
<asp:GridView ID="GridView1" runat="server" Width="100%"
AutoGenerateColumns="False" BackColor="White" >
<Columns>
<asp:BoundField DataField="lblInvoice" HeaderText="Invoice(s)" />
<asp:BoundField DataField="lblTotal" HeaderText="Total" />
[Code] ...
i have a gridview with 1 image colums
i want to be when loading images columns show a gif image.
I have two gridviews that are in within UpdatePanels each, which are dynamically filled with data and a checkbox column. Clicking on one checkox one of them (Checkbox AutoPostBack = true) , the checkbox column of the other disappears, How to I can handle the state of the gridview.
this is my code:
[code]....
I have a user control that is common to the application. It searchs for lakhs of Items in one go from the db and I set the selected Items in a list in a session to pass on to the pages that use it. Hence making the application a tad slower. The gridview that contains the Items should have sorting, page indexing. What according to u,I should do to enhance the application's performance ?
View 1 RepliesI modified a GridView control to enable alphabetical paging, and in doing so had to bind the GridView manually in the code behind rather than using the ObjectDataSource I had used originally.
Now my "delete" command in the GridView isn't working. I get that I need to handle this in the code behind now that I'm no longer bound to the ObjectDataSource.
But I'm not sure how to do that in C# and am not finding any examples.
Here's my .aspx:
[Code]....
And the .cs:
[Code]....
i have a gridview which consists of two columns.
1. name
2. radiobutton
when ever i click the radio button, the correspondng name should be saved in a variable in code behild(c#)
the gridview code looks as below:
[code].....
how to handle click event of linkbutton in gridview in asp.net
View 2 Replies I created nested gridview refereing asp.snippets.. Its working fine now requirement is to add Checkbox within child grid.. i added childgrid by
</asp:TemplateField>
<asp:TemplateField HeaderText="Approve">
<ItemTemplate>
[Code]...
How to find child grid check box control