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


Post New Web Links

Extreme Latency on SpecificFinder (but not Finder)

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#
 

I have a Oracle DB table with 3 columns and 500,000 rows.  I have successfully created an ADF, uploaded it to SharePoint, and it works.  My BDC defines a method for Finder:

Select "SSN","FIRST_NAME","LAST_NAME" From myTable where("LAST_NAME" LIKE :LastName) and ("FIRST_NAME" LIKE :FirstName) and ("SSN" LIKE :SSN)

and SpecificFinder:

Select "SSN","FIRST_NAME","LAST_NAME" From myTable Where ("SSN"=:SSN)

The queries work, but the SpecificFinder (even when placed on its own page, referenced through a Business Data Item Web Part) takes upwards of 40 seconds to load, while the the Finder returns data in anywhere from 5-7 seconds (for instance, when filtering on SSN or even when returning a large set of data filtering on Last Name).  This is totally counter-intuitive and we cannot seem to figure out why the SpecificFinder is taking so long. 

When watching the database during the execution of a SpecificFinder, we see that the session remains open for the entire 40 seconds, so SharePoint and Oracle are conversing during this period.  As soon as the session ends, the data is immediately presenting in the web part.  We know it only takes a fraction of a second to run the SpecificFinder query, so someth


View Complete Post


More Related Resource Links

SQL Server 2005: Extreme latency from Distributor to Subscriber

  

I have a publisher and a subscriber. The distributor resides on the subsciber. It is transactional replication. The SQL Server version on both servers is SQL Server 9.00.3175.00 (x86). Offlate, we noticed that the latency is huge from distributor to subscriber. The latency from distributor to subscriber starts from 1 hour and proceeds upto 72 hours in a couple of days. Due to the huge latency, the distributor db size is also growing high. However, at the same time, the latency from publisher to distributor is very low (a few seconds).

Once per day, the distribution agent fails with an error saying that the subscription has marked inactive and must be be reinitialized. However, the subscription option has been set to "never expire but can be deactivated until they are reinitialized"

Please point me in the right direction so I can investigate further. What could be causing the latency from the distributor to the subscriber?


Vijay V

Extreme ASP.NET: Model Validation & Metadata in ASP.NET MVC 2

  

Scott Allen shows how to improve your user input validation with new features coming out in ASP.NET MVC 2 that easily allow validation on both the client and server.

Scott Allen

MSDN Magazine March 2010


Extreme ASP.NET: Text Template Transformation Toolkit and ASP.NET MVC

  

The Visual Studio T4 code generation engine lets you parse an input file and transform it into an output file. We give you a basic introduction to T4 templates and show you how ASP.NET MVC uses this technology.

Scott Allen

MSDN Magazine January 2010


Extreme UI: Line Charts with Data Templates

  

Charles Petzold continues his investigation into robust XAML coding made possible by Windows Presentation Foundation, this time tackling the complicated process of creating line charts.

Charles Petzold

MSDN Magazine January 2010


Extreme ASP.NET: Looking Ahead to ASP.NET 4.0

  

When Visual Studio 2010 and .NET 4 arrive next year, ASP.NET developers will have two mature frameworks for building Web applications: ASP.NET Web Forms and ASP.NET MVC. This article highlights some of the important new features for these two frameworks.

Scott Allen

MSDN Magazine December 2009


Extreme ASP.NET: Search Engine Optimization with ASP.NET 4.0, Visual Studio 2010 and IIS7

  

In this article, the author takes a look at SEO practices that the reader can apply when using the latest Microsoft Web technologies.

Scott Allen

MSDN Magazine September 2009


Extreme ASP.NET: Guiding Principles For Your ASP.NET MVC Applications

  

In this column, the author lays out some guiding principles that you should follow when working with the ASP.NET MVC framework.

Scott Allen

MSDN Magazine July 2009


Extreme ASP.NET: The Life And Times of an ASP.NET MVC Controller

  

Here the author dissects the ASP.NET MVC framework and looks at how controllers work. He then explains how the framework interacts with your controllers and how you can influence those interactions.

Scott Allen

MSDN Magazine May 2009


Extreme ASP.NET: Charting With ASP.NET And LINQ

  

The combination of the ASP.NET Chart Control and the data querying power of LINQ lets you build flexible charts. Learn how here.

K. Scott Allen

MSDN Magazine March 2009


Extreme ASP.NET: Routing with ASP.NET Web Forms

  

See how to get the benefits of rerouting while alleviating the risks with this in-depth look at URL rewriting in ASP.NET.

Scott Allen

MSDN Magazine January 2009


Extreme ASP.NET: The Only Data-binding Control You'll Ever Need

  

Fritz Onion demonstrates how the ListView control in ASP.NET 3.5 makes data-binding tasks easier with support for styling with CSS, flexible pagination, and a full complement of sorting, inserting, deleting, and updating features.

Fritz Onion

MSDN Magazine March 2008


Extreme ASP.NET: Encapsulate Silverlight with ASP.NET Controls

  

To implement Silverlight in ASP.NET pages, you can encapsulate your Silverlight elements in ASP.NET controls. Here's how.

Fritz Onion

MSDN Magazine January 2008


Extreme ASP.NET: Web Client Software Factory

  

The Web Service Software Factory is designed to provide guidance and enhanced tools for building Web services using ASMX or WCF.

Fritz Onion

MSDN Magazine August 2007


Extreme ASP.NET: Web Deployment Projects

  

ASP.NET 2.0 development is the easiest ASP development yet. Fritz Onion reveals why.

Fritz Onion

MSDN Magazine April 2007


Extreme ASP.NET: Client-Side Web Service Calls with AJAX Extensions

  

Microsoft AJAX Library and the ASP.NET 2.0 AJAX Extensions provide a number of compelling features ranging from client-side data binding, to DHTML animations and behaviors. Learn all about them here.

Fritz Onion

MSDN Magazine January 2007


Extreme ASP.NET: Control Adapters

  

Control adapters let you provide alternate renderings of controls for mobile devices. But they can also be used to completely change the rendering of a con¬trol based on browser type, which can be useful in a number of situations.

Fritz Onion

MSDN Magazine October 2006


Extreme ASP.NET: Asynchronous Web Parts

  

Building a customizable Web site complete with a collection of pluggable Web Parts is fairly easy with the portal infrastructure of ASP. NET 2. 0. This model is very flexible, allowing users to easily place your Web Parts anywhere on the Web page so they are free to customize your site.

Fritz Onion

MSDN Magazine July 2006


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