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

Top 5 Contributors of the Month
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

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