.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Bizzare Performance issue when accessing a ushort variable

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :WPF
 
Simple situation, that I can't recreate in a test harness, but I swear to god is happening in my code in ,NET 4.0, VS2010. Release / Debug mode doesn't seem to matter.
Given the following very simplified code which is run about 20000 times during a set of calculations, having the 'if' statement commented out results in the code running in around 5 seconds. As soon as I add the 'if' statement, the time goes up over 17 minutes. I am not kidding you.  I've been looking at this for two days. Comment out one line of code that *should* reduce the number of times DoSomething() is called, and I end up multiplying the execution time by a factor of over 350.
public class Foo()
{
 private ushort _month;

 public ushort Month
 {
   get { return _month;}
   set { _month = value; }
 }
 
 public void Calculate(ushort inputMonth)
 {
   if (_month < inputMonth)
    DoSomething


View Complete Post


More Related Resource Links

Issue accessing textbox controls nested within a DetailsView within an UpdatePanel

  
I have a couple of textboxes nested with a detailsview, within an updatepanel.  When I try and access them from the code behind, it returns a null value as if they don't exist.  Can't figure out why that would be.ASPX code is: <asp:UpdatePanel ID="upSpecificShout" runat="server" UpdateMode="Conditional" ChildrenAsTriggers="true" > <ContentTemplate> <asp:DetailsView ID="dvSingleShout" DataSourceID="sdsSingleShout" runat="server" AutoGenerateRows="false" OnDataBound="SetDVIcons" HeaderStyle-CssClass="noDisplay" > <EmptyDataTemplate> <p class="Watermark"> The panel on the left shows a list of everything you've shouted. (Your replies to other shouts are highlighted in blue/green.) </p> <p class="Watermark"> This right hand panel will show specific shouts with a list of replies etc.. Just do a little click on a shout title to display more detail here. </p> <p class="Watermark">

Performance Issue on SQL 2008 Box

  
Will SSRS and SSIS running on the same machine would hinders the perfromance of a database engine. 1. If so to what extent? 2. How do you tackle this kind of issue. 3. Is there a way you can separate these services from running on the same machine. The machine also has a OLTP database running on it.

XOML only workflow performance issue while creating

  
  In our application we are using XOML workflow and create workflow instance using workflowRuntime.CreateWorkflow(workflow, ruleReader, workflowParameters) where workflow and ruleReader are objects of XMLReader created using XmlReader.Create().For one of our business process automation we have developed XOML only workflow which has 35 states and 95 events. When we try creating an instance of the workflows it is taking more time and the time taken to create the instance is 3 min.Can any one suggest is there any other way to create workflow instance of XOML only workflows other than workflowRuntime.CreateWorkflow(workflow, ruleReader, workflowParameters)Your help is higly appreciated.Environment:    VS 2008    ASP.NET 3.5    WWF 3.5    XP  

Variable issue - SQL Server to Oracle

  
i use a variable (date type is Object) to store number from sql server, the format is: 123 456 789,00 (Norwegian) when i execute the package and sync it to Oracle (the input parameter is numeric), then an issue occured, it said can not covert the string to numeric. how to transfer it to the stardant format: 123456789.00?   thanks

Gridview Performance Issue

  
Hi All, I have one ASP.NET Application (VS.NET 2005). In that i have one scenario where i have to display 500 records per page (Not less than that bcoz this is client requirement to display 500 records per page) in the Gridview. This functionality is working fine but the application is becoming very slow. Can anybody tell me the solution for increasing performance in this case ???? VERY URGENT...PLZ REPLY SOON Thanks, Biswajit

.NET 4 Performance Issue String IndexOf

  

Hi,

I have a performance issue with the new dot net 4.0 framework.

When i use the function String.IndexOf(string, stringcomparison.ordinalignorecase) my execution time is much higher than framework 3.5 (i had 30ms in a loop for 3.5 and 210ms in framework 4)

All other StringComparison mode are really good in framework 4.

Is there an explanation?


Performance Drop when switching from a #temp table to a @temp table variable

  

I am trying to convert a stored procedure to a table valued function and the performance has taken a HUGE hit and I was wondering if there was anything that can be done about it. Since a table valued function can not use #temp tables it must be converted to a @temp table variable.

Here are some steps I have already taken...

The original stored proc starts off by populating a #temp table via "Select x Into #temp ..."

Leaving it a stored proc for now, I explicitly created the #temp table and did an "Insert Into ... Select From" to more closely model how it must work when using a @temp table variable. There was no discernible performance difference.

Still leaving it as a stored proc, I then swapped out the #temp table with the @temp table variable and now, all of the sudden, the performance drops from sub-second to over a minute!!!

The temp table only has one field defined as an int and it is distinct, so I tried making the field the Primary Key to see if that would help and it did not.

The temp table is created by scanning a table with around 11,000 rows and the temp table itself has about 4400 rows in it (if it makes a difference to anyone).

Does anyone have any suggestions (or hope) for me?

Thanks,
Jim


performance issue

  

i am having an issue in queying a table. This is something thats happening since the last 2 days. whenever i try to open a table (rightclick --> open table ) it errors  out saying the query time out period elapsed before the completion of the operation or server is not responding. But when i query select * from tablename..it is taking some time but is returning the results. The query time out period is set to 0(indefinite time out). we have never seen this kind of issue before. There are no open transactions either to assume that something is locking the system(dbcc opentran returns there are no open trans). Wondering why this is happening and also the performance of the system has gone down completely. Please help us in this issue. I checked the indexes for fragmentation and could see in some of them avg_fragementaton_percent like 60, 70, 80. i guess it is not good to have high such a value, so i ran dbcc reindex but still did not improve the performance. the avg_fragmentation was still the same.

Please advice. 


Issue with WCF performance

  

We have several WCF (3.5 hosted in IIS7) web services that are having some strange and inconsistent performance issues. In some environments they run fairly quickly. In others they time-out even if we significantly increase the timeout. We have tried all of the advice for performance tuning an IIS 7 hosted WCF service to no avail.

The svc log however shows some odd beheavior I am not sure how to interpret. I will get a message saying Opened System.ServiceModel.InstanceContext/..... The next message will say "A message was read". all good except it takes over six minutes sometimes. I do not follow these logs well enough to understand what could be causing this.

If anybody could provide any help or guidance, it would be greatly appreciated.

Best regards,

Ryan

 Additional information: Just realized that the servers where we are having the large delays reading the message have Symantec "Data Endpoint Security" installed. Seems like it could be related. anybody have familiarity with this AV client and WCF?


Performance Issue.

  

Hi,

I have a query which involves a table and a function. Table has got around 59 crores of records and the function returns 56k records. There is a inner join between with function being on the left side. This query takes around 2 minutes to execute. I wanna improve the performance to few seconds.

I made sure that the table has all required indexes but still was not able to improve the performance.

Please suggest what else i can do to improve performance.

Thanks,

Deepti

 

 

 

 


Performance Drop when switching from a #temp table to a @temp table variable

  

I am trying to convert a stored procedure to a table valued function and the performance has taken a HUGE hit and I was wondering if there was anything that can be done about it. Since a table valued function can not use #temp tables it must be converted to a @temp table variable.

Here are some steps I have already taken...

The original stored proc starts off by populating a #temp table via "Select x Into #temp ..."

Leaving it a stored proc for now, I explicitly created the #temp table and did an "Insert Into ... Select From" to more closely model how it must work when using a @temp table variable. There was no discernible performance difference.

Still leaving it as a stored proc, I then swapped out the #temp table with the @temp table variable and now, all of the sudden, the performance drops from sub-second to over a minute!!!

The temp table only has one field defined as an int and it is distinct, so I tried making the field the Primary Key to see if that would help and it did not.

The temp table is created by scanning a table with around 11,000 rows and the temp table itself has about 4400 rows in it (if it makes a difference to anyone).

Does anyone have any suggestions (or hope) for me?

Thanks,
Jim


Accessing static variable in global.ashx file

  

Hi All ,

I want to access the static variable in my global.ashx file  I am using classname.variable name for accessing the variable but the variable name dose not appear.Can someone tell me how to access static varialbe in *.ashx file.


Sql Server compact Edition Performance issue

  
I was  trying to insert a .wav file to sql server CE..The file is of size 1 Mb,but it takes a long time to perform the action (more than 1 min).Anybody have solution ? please help me..

Performance Issue

  

we did a performance check on production and found that an object is missing from the Layout page which causes the below error frequently.

 When we check the log file we get the below error

1. SearchUpgradeGetKeywordPropertyBag keywordsPropertyBag is null

2. Cannot open file "Resources.en-US.resx" for reading.
(#3: Cannot open file "Resources.resx" for reading.)

3. While initializing navigation, found Page placeholder but object was not found at: /GLOBAL/COMPANY/ORGANISATION/OPERATIONS/DELIVERY_CAPABILITY_MANAGEMENT/PRODUCT_DATA_MANAGEMENT/PAGES/DELIVERY_DATA_PROVISIONING.ASPX.

Most of the time SearchUpgrade and Cannot open file error are followed by While Initializing navigation error.

And we receive a deadlock error in the IIS(ISAPI.dll) at the same time when we receive this error.


vs 2010 performance issue

  

we have migrated our application from vs 2005 to 2010 we found that page loading time is increased 

any idea why this is happing or how to improve it 


Performance issue with GridView

  

Hi All,

             i am facing performance issue while using the datagrid in my project, i am writing my code here please correct me if i am writing something wrong.


i am using sql server 2000 in which i have a table containing around 600000 records and i can not put any indexing on this table as this is the staging table for me .

now To show these record on front end i am using gridview with Allowpaging = "True" now in the PageIndexChanged event i have to again hit the database and bind the grid which results very slows performance as just to change the page i have to read 600000 records again and again, i am giving some idea below what i am doing


Public Void BindgridView()

{

//do database connection

//fill the dataset through adapter

Gridview.datasource = dataset();

Gridview.databind();

}



protected void GridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
      GridView1.PageIndex = e.NewPageIndex;
      BindgridView();
}


Any idea how can i imrove the performance, Please help me out..


Thanks,

Ankur




Updating multiple Indexes on a table - Performance issue

  

Hi

I have a performance issue when trying to update a table with multiple indexes. The table itself has about 280 million rows. The selection of the records is fast, about 160 ms, as it has a suitable non-clustered index. However the update itself takes over 10 minutes.

When I look at the excution plan, it shows the update to the clustered index as well 5 other non clustered index which are being affected by the statement. Unfortunately it doesn't show me how those indexes are being accessed. I suspect that the update statement is performing a full index scan against each of the non-clustered indexes in order to do the update.

So my question is this, if i add the key columns of the other non-clustered indexes as included columns on the index used to select the records for update will sqlserver use them to access the additional non-clustered indexes?

any advice greatly appreciated

Conan


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend