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


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

Slow startup. Waiting for MEX data for 40 seconds.

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :WCF
 

Hi all,

I'm tearing my hear out, and I don't have that much hair left to start with.  I have a WCF program that takes 41 seconds to start. For 40 of those seconds it's sitting waiting for the MEX data.  It runs fine after that.  Here are the details:

  • Running on Windows 7, and I can't try it on another machine.  This is the machine it has to work on.
  • Compiled with Visual Studio 2010 with .NET 4.0 as the target
  • I'm not running in Administrator mode, and it doesn't help anyway, when I tried it. (And I can't imagine why anyone would do that, but that's another story!)
  • The endpoint is using the named pipes protocol, so I can't set "UseDefaultWebProxy = false".
  • I tried other protocols including the HTTP protocols and TCP.  It doesn't change anything.
  • I have no security set at all.
  • I added the <generatePublisherEvidence enabled="false" /> because I understand that can help if the lookup is searching for expired certificates.
  • I tried it with one base address -- for the named pipe; and with the current two base addresses.
  • While it's sitting there for 40 seconds waiting for the MEX data, my internet browser hangs.
  • Also, when looking at the trace I notice that before listening for MEX, it constructs a ServiceHost and the


    View Complete Post


More Related Resource Links

Slow Data Return

  
Using Sharepoint 2010 and Infopath 2010 - I have a form that has a sharepoint list that it queries for data. I have tried to have it load upon opening the form and also had it query the data after it loads after something is changed. Either way it makes this form extremely slow. Frankly it is not that large a list. (484 entries of company names, address, city, state etc.....) Anyway, after reading some posts I saw a recommendation to use REST to query the list. So I set that up. I now have a secondary REST data source that loads upon form load. The issue is now that when I try to load the form I get the following error - "The amount of data that was returned by a data connection has exceeded the maximum limit that was configured by the server administrator". So I am looking for some advice as well as some instruction. First - is REST better, worse, the same as far a response time? 1. Using the traditional query list as a secondary source using a regular data source connection for this size list should I be getting this kind of poor response? My form is using some cascading dropdowns and some query rules. 2. If REST is the way to go, how do I overcome the error message I am getting? Thanks      

Slow startup of SSIS package if started using a SQL Server job

  
Hello all,   We have noticed in our environment slowness when starting SSIS packages from SQL Server jobs. I did a quite detailed study on when the slowness actually occurs and what are the consequences. Here are the results.   The SSIS package execution is slow if all the following is true: The package is started from a job. If started directly as a SSIS package, the execution is fast. The job is running on a 64 bit Windows Server (SQL Server 2005 SP2). The SSIS package and the job are either on the same server or on different servers (the second server is SQL Server 2005 SP1). If the job is run on a 32-bit workstation (Windows XP SP2) the execution is fast (the SSIS package still being on the server). The package contains tasks. §         If there are no tasks, just an empty sequence container, the execution is fast. §         If a package that has no tasks has logging into the database configured, the execution is fast. §         Slowness has been verified with A) a package having a single Execute SQL statement and B) a package having a Send Mail task. It doesn't seem to matter which user account is used on when running the job.   The slowness happens in several locations, e.g. (there are also others, at least the following have been verified) There is exactly 30 seconds lag between starting the job (as seen from job history) and when PreValidate (as seen in the sy

Data Transfer in C# slow when targeting SQL Server 2005 using SQL Server SMO version 10 (distributed

  

 

Hello everyone,

I have a strange issue regarding SQL Server SMO Transfer. I am using the Transfer class to create a copy of a database. I will explain the different cases I have tried so far and maybe someone can help me figure out what's going on.

First case

I run my C# code from an assembly that references version 9.0.242.0 of SMO assemblies that are in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2005 database engine, it works perfectly and fast.

But of course, as soon as I try to target a Sql Server 2008 database engine, it complains that it is not compatible. No surprise there.

 

Second case

I run the exact same C# code from an assembly that references version 10.0.0.0 of SMO assemblies that are also present in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Management.Sdk.Sfc
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.Smo.Extended
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2008 database engine, it works perfectly and fast.

However, if I try to target the sam

Data Transfer in C# slow when targeting SQL Server 2005 using SQL Server SMO version 10 (distributed

  

 

Hello everyone,

I have a strange issue regarding SQL Server SMO Transfer. I am using the Transfer class to create a copy of a database. I will explain the different cases I have tried so far and maybe someone can help me figure out what's going on.

First case

I run my C# code from an assembly that references version 9.0.242.0 of SMO assemblies that are in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2005 database engine, it works perfectly and fast.

But of course, as soon as I try to target a Sql Server 2008 database engine, it complains that it is not compatible. No surprise there.

 

Second case

I run the exact same C# code from an assembly that references version 10.0.0.0 of SMO assemblies that are also present in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Management.Sdk.Sfc
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.Smo.Extended
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2008 database engine, it works perfectly and fast.

However, if I try to target the sam

Slow on data retrieval for the every 1st time

  

Hi all,

I had developed a POS system which connected to a local database (MS SQL SERVER EXPRESS 2005).

I'm facing an issue whereby after the cashier key in barcode, the description, price per unit will be displayed very slow for the every FIRST time. The susequent items will be very fast.

This happen when the system is idle for sometime. If continuous use, will not have this issue.

Any advise or setting i can do to improve this performance issue?

Thanks.

Didier

 


SSIS - Data Flow Task Reads Fast But Importing the Output,Update & Deleting Extremely Slow & runs lo

  

Good day, I need help please.

In my source I read about 4mil records in a matter of seconds But Importing the Output to the Same Table takes about an 1 hour to update.

My Source Read is the Same Table to which i'm Importing, Updateing,Deleting

Importing: Table Lock & Check Constraints are checked

Please any ideas & suggestions will be great.

Thank You


Slow startup of NET application if the computer is connected to LAN

  

Before first statement of Main method is executed my application hangs for 30 sec. If i disconnect computer from local network, this delay goes away.

I tried to profile with TCP View: my application does not open any connection. During delay svchost opens UDP connections from various ports (each application's start ports are different) (Remote address = *, Remote port = *) 

framework 3.5 Windows XP

 


How to decrease data waiting time?

  

I have some difficulties in one of the web based projects that I've developed.

It's a country wide project and database is big, so the waiting time is getting increasing.
I tried to write non- complex queries and set up index on some important fields that are being searched as well.

Is there any other way to enhance the efficiency and performance?


.NET 4.0 WPF x64 Slow Application Startup

  

Hello and thank you to everyone in advance that takes time to assist me.

I have been having some issues, although not serious or breaking they are rather annoying.  The issues have to do with a 64 bit .NET 4.0 WPF Windows application (even a simple one with one blank window) upon execution, it can be a cold or a warm start and it makes zero difference it starts up at a noticeably slower speed.  Here are my core system specs just as a reference:

CPU: Intel Core i7 x980 Extreme, GPU: Nvidia GTX 295, Memory: 12 GB OCZ Platinum, HDD: 300 GB Intel X25 SSD RAID 0

Windows 7 Ultimate x64

Stated are my new specs, my old computer had the exact same issues with similar specs, so I do not think it is hardware related (I hope).  The following are all the scenarios that I exhausted trying to figure out what is going wrong:

.NET 3.5:

All architectures and technologies worked as expected and executed very fast at startup.

.NET 4.0:

WinForms Any CPU, x86 and x64 all execute very fast at startup.

WPF x86 executes very fast at startup.

WPF Any CPU and x64 much much slower than the tests above, the application takes 5 seconds + to load.

All of the above tests were compiled with Visual Studio 2010 Ultimate.

I decided to copy this simple .NET 4.0 WPF x64 application to my la

One user in group waiting results forever using BDC data filter

  

I gave a group of users to be able to search a plan name through a BDC filter on SharePoint 2007. All the users have no problems to access BDC data sources, but only one user in the group got waiting on the searching results forever. But this user has no problems to use any other SharePoint features.
I will appreciate it your any ideas.

Dong


SharePoint BDC data search waiting forever

  

Hi,
I have a SharePoint BDC filter access issue with only one user in a group of users.
I gave a group of users to be able to search a plan name through a BDC field. All the users have no problems, but only one user in the group got waiting on the searching results forever.

So, could you please give me any ideas what may cause this problem happened?

Thanks for your help,
Dong


Binding WPF Controls to an Entity Data Model

  
In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

  
In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

  
In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

  
Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

  
At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.
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