List Iteration Taking So Much Time?
Oct 13, 2010
I have List (of class). having 1800 of count and each object has 90 properties. When I terate earch with 90 properties taking more and more time. How to resolve this
Dim cellIntStyle As HSSFCellStyle = hssfworkbook.CreateCellStyle
cellIntStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("#")
Dim cellDateStyle As HSSFCellStyle = hssfworkbook.CreateCellStyle
cellDateStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat(Format
("dd-MMM-yyyy"))
For Each mReport As Report In dtExcel
row = sheet1.CreateRow(iRow)
j = 0
For Each prop As PropertyInfo In props
Dim value As Object = prop.GetValue(mReport, Nothing)
If IsInt(value) Then
CreateRow(row, j, CType(value, Integer), cellIntStyle)
ElseIf IsDate(value) Then
CreateRow(row, j, String.Format("{0:dd-MMM-yyyy}",
value), cellDateStyle)
Else
CreateRow(row, j, value)
End If
j = j + 1
Next
iRow = iRow + 1 // Coming here taking so long... how to make it fast.
Next
Private Sub CreateRow(ByRef row As HSSFRow, ByVal colId As Integer,
ByVal value As String)
row.CreateCell(colId).SetCellValue(value)
End Sub
Private Sub CreateRow(ByRef row As HSSFRow, ByVal colId As Integer,
ByVal value As Integer,
ByVal cellStyle As HSSFCellStyle)
Dim cell As HSSFCell = row.CreateCell(colId)
cell.SetCellValue(value)
cell.CellStyle = cellStyle
End Sub
Private Sub CreateRow(ByRef row As HSSFRow, ByVal colId As Integer,
ByVal value As String,
ByVal cellStyle As HSSFCellStyle)
Dim cell As HSSFCell = row.CreateCell(colId)
cell.SetCellValue(value)
cell.CellStyle = cellStyle
End Sub
View 4 Replies
Similar Messages:
Jan 13, 2010
I am making some application in asp.net 1.1 in that I am displaying data in datagrid from database. In data grid first column is of check box and radio button and in the last column we have text box now thing is that when i click on check box crosponding textbox we fill some figure and at the end we press calculate button to get total. After getting total we have to press continue button to go next step
But suppose if some body remove that check the we should press calculate button or chnage some figure in the text box then we should press calculate button again to recalculate. for that i kept autopost back on check box oncheckedchanged event and text box ontextchanged event and hide continue button so user will click calcutae button abd then continue button will re-apper
Problem it that it taking too much refresh and taking long time. So was lloking for some ajax method to use in my application.
View 8 Replies
Mar 8, 2011
I'm doing some custom code for a SharePoint webpart in C#. Specifically, I'm making a quiz, my main point here addressing the list that holds the question, answer choices, and correct answer.
At the last stage of the quiz I need to check the answers selected by the user against the correct answer in the list. Currently, I'm doing the following to check if each is correct, which I'm assuming isn't very efficient because it iterates through each question. Is there a method, specifically for the SPList foreach loop, that would be more efficient?
// 1. Store questions and answers in class
List<submittedAnswers> answeredQuestions = new List<submittedAnswers>();
// 2. From POST pull answered question IDs and answer IDs (which correspond to the question primary key and answer choice number both stored in the list)
// INSERT BEAUTFIUL AND EFFICIENT WHILE LOOP HERE
// 3. Loop through each question is list, if question was given, test if correct/incorrect
using (SPWeb myWeb = mySite.OpenWeb())
{
SPList answerList = myWeb.Lists[questionList];
foreach (SPListItem quizEntry in answerList.Items)
{
int pullAnswerId = int.Parse(quizEntry["Answer"].ToString()); // Pull answer number from list
int pullQuestionId = int.Parse(quizEntry["ID"].ToString()); // Pull primary key of question
submittedAnswers result = answeredQuestions.Find(delegate(submittedAnswers e) { return e.questionId == int.Parse(quizEntry["ID"].ToString()); });
if (result != null)
{
if (result.responseId != pullAnswerId) // If the response was different from the answer
incorrectAnswers++;
else
correctAnswers++;
}
}
}
// C# quiz grading magic here....
View 4 Replies
Aug 25, 2010
Issue:
As my pages are taking time to load first time.
So user has to wait till full page gets loaded and thats irritating . Was this the reason MVC was evolved?
Solution :Should i use partial rendering on all pages including home page, and all forms getting called from home page.
So even if half page is loaded thats less frustrating
For Partial rendering what i plan is : i will put Scriptmanager with Enable partial renderingand update panel for half part of page.
So that user dont have to wait for full page to load.
Is my plan correct? Problem is i cannot regenerate page load issue every time.
View 4 Replies
Dec 5, 2010
when i am runnig the project, the crystal report(rpt) file will taking too much time for loading on first time... any one please help me to avoid the time delay for loading the rpt file in first time .
View 2 Replies
Oct 29, 2010
I am having a Gridview which takes much time to load its data, I tried to make the loading faster by implementing paging in gridview and reducing the rows to render in the grid and it got worked to an extent but still it lags in processing to bind data. The database i am using is SQL Server 2005 and the code is as follows
DataTable dtProducts = objProducts.GetProductDetails(iCat.ToString(), userId);
dgrdProductList.DataSource = dtProducts;
dgrdProductList.DataBind();
public DataTable GetProductDetails(String CatID, String UserID)
{
DataAccess DAB = new DataAccess();
DataTable dtbProducts = new DataTable();
try
{
string SQL = "select *,CAST(ShortDescription AS varchar(200)) AS ShortDescriptionList from vw_products where IsActive=1 AND CategoryID = " + CatID +
" AND LanguageID in( SELECT PW_UserLangRel.LanguageID FROM PW_Language INNER JOIN " +
" PW_UserLangRel ON PW_Language.ID = PW_UserLangRel.LanguageID WHERE PW_Language.IsActive=1 AND PW_UserLangRel.CompanyID=" + UserID +
" ) Order By ID Desc,LanguageID";
dtbProducts = DAB.Fill(SQL, CommandType.Text).Tables[0];
}
catch (Exception ex)
{
throw new Exception(ex.Message + "WebShopPaolo.CProducts.AddProductImages");
}
return dtbProducts;
}
View 1 Replies
Oct 4, 2010
I have tested my pages in Firefox & IE and looking at Firebug in Firefox for some reason some images are taking a long time to load. They are not very big in comparison to the ones which are loading quicker.
Attached is a screenshot of Firebug.
I especially notice it in IE with the progress bar at the bottom of the page, it just sits there saying loading image...
Could it be the path or something which is http://localhost:49211/Content/_layout/images/bg-footer.png for example
View 2 Replies
Jun 12, 2010
I want to alert some message on the click of a Button which is inside the Update Panel. Therefore I used "scriptmanager.registerstartupscript" but after using this I found that my event started responding slowly. Can anyone please help me in finding an alternative of "scriptmanager.registerstartupscript".The point that needs to be noted is that the button is in an Update Panel. And its my cenessity to find some alternative of it.
View 3 Replies
May 20, 2010
We are using asp.net ajax 1.1 (and can't upgrade to latest for internal known reasons). We are having a page where we call ScriptService method through ASP.Net ajax and oncallback of result, we bind that result to Html controls on the page. During testing we observed that this whole process is taking too much time. When we profiled using IE8 developer toolbar, we observed that there is one standard function from ASP.net Ajax frameworks' own JS. Function name is function$_validateParameterType and it is the one which takes maximum time amongs others. Is there any way we can reduce the time take by this. Is there any standard practice for such requirements.
View 1 Replies
Jun 29, 2010
I'm using data access block [URL] in asp.net 3.5. Back end is sql server 2005. It's working fine and returns result instantly for all DB calls. But, I've a problem with one SP. When I call it, executereader is taking too much time. In few cases, it is executed. And sometimes I get the Time out error. I run the same SP in sql server. It returns 9000 rows in 3 seconds.
View 3 Replies
Apr 20, 2010
The home page of my website and some other page also are taking some time to load, instead of making them load fast, I want some please wait screen or progress bar and mean while the required page would be loaded behind.
View 3 Replies
Nov 19, 2012
I have a web page and i have one user control and one buttone on page...
I am displaying some data on that page.
But problem is that buttong is loading after almost 30 to 40 seconds event after whole data displayed and progress bar of ie is also does not complete
View 1 Replies
Aug 10, 2010
i have a loging page, once i login into my application it is redirecting into main dash borad screen. where i am displaying data from other server. it is taking time to load page..
case 1:- in my dashboard one block i am displaying some simple info like alerts, news, mails count..etc.. that is comming from my local database ( there is no performance issues on that..)
case 2: in the same page (dashboard block) i am showing data, it is comming from another server.. first it will check the credentials and retrive data and displaying in same dashboard screen ( here it is taking time)
once hit the login button and redirecting into a dashbard screen using response.redirect("dashbard.aspx"); it is redirecting to dashbard screen..once all the process of page load is comple,,,then it is displaying the dashboard page what i am looking is first i want to redirect to the dashboard screen and then process the case1 ( simple data ) ..and for case2 i just want to show some ajax spinner image on the second block..
View 7 Replies
Nov 1, 2013
Change image on mouseover taking too much time in firefox and internet explorer but work ok in chrome...
Code I used is below:
<img id="img1" onmouseover="this.src='/slideworld-homepage/images/f2.png'" onmouseout="this.src='/slideworld-homepage/images/f1.png'" style=" height:36px; width:36px; border:none;" src="/slideworld-homepage/images/f1.png">
View 1 Replies
Aug 23, 2010
I am using making application asp.net 2.0. In my page there is Data List which is having two buttons. When user click on the button it is doing some process and taking some time. Due to that user some time click twice and it will make problem in application. So to stop that I wanted to show progress bar until button click process done.
View 6 Replies
Aug 5, 2010
Whenever I add an entry to the Hosts file on Windows, it takes a long time for the change to take place? I have tested using Firefox and IE and it seems to take around 5 minutes on both of them before the new IP/Domain entry on Hosts is recognised.
Is there anything I can do to overcome this? Perhaps "refreshing" the cache in some way? ipconfig /flushdns doesn't work.
View 1 Replies
Mar 24, 2010
When I Publish my website it takes around an hour and a half. This is publishing to a directory on my local machine, it is not FTP'ing to a remote server. The build seems to take about an hour (when I build without publishing it is noticeably slow, but 5 minutes slow, not an hour), then the publish seems to take a further half an hour.
what could be causing this and how I can improve this? This obviously causes issues when I make a change (I'm constantly updating the site) as I need to wait for an hour an a half. I'm considering not precompiling the site now and simply uploading the .aspx and .cs files direct to the server as this is unmanageable for me.
View 5 Replies
Oct 13, 2010
At work I'm tryhing to upgrade an ASP.NET 2.0 app (which we wrote using VB.NET 2005) to ASP.NET 4.0. I had a few problems during the upgrade, but eventually worked them all out. At the end of the day I decided to give it a quick compile and see if I'd get the start page, so I hit F5 in VS 2010. I left it that way, and man was it acting weird. VS 2010 wasn't responding to anything. If I hovered the mouse over VS 2010's minimize or close buttons, in the upper right corner, then those buttons were flashing very rapidly. I'm not sure what was going on. After waiting 15 minutes to see if it would come up, I decided to try clicking on the close button. Nothing happened. Eventually, I had to leave (I take public transit, and I have to leave when the bus comes)But what I want to know is this, is this pretty standard behavior? Does it normally take this long to do this? This website is of modest size (<100 pages).
(Later) When I came into work today, 8 hours later, VS 2010 was still doing whatever the heck it was doing, but basically it wasn't responding to anything.
View 1 Replies
May 7, 2015
I had implemented the Ajax timer control to update Gridview data(along with Progress bar inside Gridview) after some interval of time.Below is the full code:
HMTL:
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<%--style & Script for progress bar in Gridview --%>
<script type="text/javascript" src="//code.jquery.com/jquery-1.10.2.js"></script>
<script type="text/javascript" src="//code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
<link href="css/jquery-ui.css" rel="stylesheet" />
[Code] ....
C#:
protected void Page_Load(object sender, EventArgs e) {
if (!this.IsPostBack) {
BindGrid();
} }
protected void BindGrid() {
string query = "SELECT * FROM Table";
[Code] ....
It is working fine except that the Gridview paging is taking some time(15-20 seconds) to go to next page.
View 1 Replies
Feb 20, 2010
I have an application which imports data from csv to sql server 2005. It is taking long time to import data from csv to sql server 2005. it has a timer. on tick of timer, I am checking if current rown in csv exists in database. If it exists, It is not added to sql server otherwise, It is added that row to sql server 2005. Also, In page load, It checks on each tick, whether user is logged in or not. it adds value to log file that user is logged in. How can I optimize this ?
View 1 Replies
Nov 6, 2010
I am fetching data from .xls file and storing it in to database. Then my users work on a single table where I stored all .xls data. But the problem is that it takes tooooo much time.. So, I want to use cache. But I never used this... Can any one tell me this example how can I use cache with database for increasing application speed?
View 2 Replies
Jan 19, 2010
I'm using vs2008 and add a dropdown list in my page. Default value of this control is "Digital". When I select another value from the list and press a button, next time the page displaying the same value, i.e Digital, not the selected value. I just want to show the selected value on the page.
View 2 Replies
Nov 22, 2015
I have a big form in which i have almost 10 update panels. some are having updatemode = conditional and others are always. Now by default when that page is opened i only show one dropdownlist.When that project dropdownlist (from which i populate the rest of the elements in my page) value is changed by user it takes long time to load the other elements. Also the other gridview which is also surrounded by update panel and mode in conditional takes long time to show edititemtemplate controls in edit mode.
I am unable to trace the reason behing delay. Few days ago it was working fine and fast but now it is slow.
View 1 Replies
Mar 22, 2011
I have query that returns a line that looks like this belowA NEWYORK PROGRAM AA NEWYORK PROGRAM Bnow, the NEWYORK is inputted into a dropdownlist and the program A and program B is inputted into a dropdownlist as wellI am using utility.ControlTools.SetListControl for my dropdownlist. I would like a situation where my dropdownlist only contains one NEWYORK instead of two and my dropdownlist for programs to contain Program A and program B. Can this be done.
View 2 Replies
Mar 24, 2010
I have Gridview control with all rows are edit mode using Itemtemplate and footer template. Some of columns are having ajax calendor control.
Page is very slow. If I am loading 500 rows into GridView
View 4 Replies