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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Is this load full or matching one only... coz of need to know performance

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net


This my Two Table i have one doubt...

For my first table i have select Top 2 from Employee_info 

and second table itz just selct * from MDEp..

What my doubt is on loading the above report?

Is this load all the record from MDep or just matching one based on Employee_info..?

View Complete Post

More Related Resource Links

Full text performance of a certain query

I am doing a full text query on a very simple table and when I include the search term "y5v" in the conditions it slows the query down like 8 to 1. The table is defined as: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tblTextSrchData]( [intItemId] [int] NOT NULL, [srchTxt] [varchar](max) NOT NULL, CONSTRAINT [PK_tblTextSrchData] PRIMARY KEY CLUSTERED ( [intItemId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] Here is the query: SELECT II.intItemID, KEY_TBL.[RANK] as Score FROM tblItems II INNER JOIN CONTAINSTABLE(dbo.tblTextSrchData,srchTxt, '("capacitor" OR FORMSOF(INFLECTIONAL, "capacitor") OR "capacitor*") AND ("active" OR FORMSOF(INFLECTIONAL, "active") OR "active*") AND ("y5v" OR FORMSOF(INFLECTIONAL, "y5v") OR "y5v*")') KEY_TBL ON KEY_TBL.[KEY] = II.intItemID If I take any of the additional search terms out it improves performance.  If I remove the yv5 search term the results are returned in less than a second. What seems to be the problem is for some reason when I add yv5 it starts doing these sorts after the full text matching.  These sorts take most of the time.  I'm not sure

Difference between delta load and incremental load and full load

Difference between delta load and incremental load and full load

Re creating indexes while data load - Performance Consideration



In the ETL design we have followed drop index before data load and recreate it after load. But looks like this approach is time consuming.

Is there any better data load design approach? Will table partition solve this problem?


- JL

Performance(Load/Stress) testing in the SharePoint 2010?


I have SharePoint Server 2010 Enterprise based small farm. Farm consist of 2 servers. All users are in AD. This Intranet portal is currently on development phase and we don't have all 300 users active. There are currenly only 10 users who are part of the development project.

How to test performance of the SharePoint farm?

In past, I used to test performance of SharePoint 2007 with SQL Server Profiler and Windows Server 2003 Performance Monitor. Is this method good enough to measure actual performance? Any better tools for this?

How about load testing of SharePoint 2010 Server?

Is there tools can generate loads and reports?

Any experience about Load testing with Visual Studio 2010?

Load testing tool the Microsoft SharePoint 2010 Administration Toolkit is for testing SharePoint 2007?

Is Load testing tool totally wrong tool for SharePoint 2010 Server?



performance comparision between IS and direct load using SQL Query


Hi Team,

I have a question on the performance of the SSIS compare to normal load..

its a direct load but when i am doing using an SSIS Package its taking lot of time to load compare to direct load using sql.

the total records in a table is 4M when i load using a sql query to another table it took some 5 mins but when i try doing using ssis it took 5 mins to load 20k records....

can somebody tel me why is this? I am very new to IS!!




Workflow Designer 4.0 Load() Performance Issue: possible memory leak?


Hello everybody,

I am trying to implement a workflow designer in a windows form application and use the same designer to view different workflows. However, I found the program became slower and slower after loading several workflows.

my steps are as follows:

1. create a wpf user control WFDesigner to package the workflowdesigner;

2. In the user control  WFDesigner , implement a InitiateDesigner method which create a new workflowDesigner instance each time called. I suppose the old workflowDesigner instance would be collected by GC;

3. create a winform application and install the user control created on step 2 to an element host, and put the element host on the form. 

4. add two buttons for test: one will execute  WFDesigner.InitiateDesigner() once and the other will execute it 100 times.

General Application Performance - Speeding up Load Times...



I'm not sure if this is possible, or if perhaps I'm not thinking .Net enough for the idea, but I'm coming from a perspective of process creation and assembly loading, that appears to be much slower than I would desire. 

When creating a Win32 API application (non-.Net) in say Delphi or C++, and using Win32 DLLs I can statically or dynamically link the dlls and either way it doesn't really have much apparent issue on the loading of the application. 

I Currently have several library Assemblies which are "Engines" as they were that are used by other "control" assemblies that are used by the application.  So IN all effect there are 10 total assemblies to this application.  Now, when debugging, I've noticed the assemblies being loaded in sequence down at the bottom status bar of VS.  and sometimes given the nature of a rather full desktop of applications I don't always see the Splash screen.  However when I just run the application, not through VS for debugging, but i've installed it on another computer and just run the short cut to the exe, and even on average modern systems it can sometimes take 15 or 20 seconds (maybe more) before the splash screen even displays.  On slower systems this can even be extended to a full minute.  I'm wondering if my design of having t

how to have full and incremental load in a single package


I have two separate packages one for full laod and the other for incremental load.

In full load I will be truncating the destination table and loading the data but in incremental I am using lookups for checking the record whether it is new or old record.

Is it possbile to have a single package so that if I select full load ,it should do full load or else it sholud do incremental skipping trunctaing task and perform the load operation.


performance Simple and Full


Hello all,

It is very basic question, today because of some situation myself and my friend started arguing about Performance of recovery models.


I proposed Full recovery model have good performance and my friend proposed Simple recovery have good performance.


Can some recommend us which recovery model has good performance?



ASP.NET Best Practices for High Performance Applications

This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

Top .NET Performance Problems and how to avoid them

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

High-Performance .NET Application Development & Architecture

It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

How to improve the performance of ASP.NET MVC web applications

It is an in depth analysis of a Digg-like site and how it went from serving (on a test machine) 6 req/sec to 390 req/sec.

The biggest gain, 74 req/sec to 390 req/sec happened when he introduced data caching and another 25 req/sec where gained when he introduced the compilation of LINQ queries.

High Performance ASP.NET - Speeding Up ASP.NET Pages

have been writing a series of blog posts, which I have named High Performance ASP.NET Websites Made Easy! There is no rhyme or reason to the order of these posts and certainly can be read in any order:

Developing High Performance and Scalable ASP.NET Websites
Avoid Chatty Interfaces Between the Tiers in Your ASP.NET Web Application
ASP.NET Page Profiling - Page Tracing - High Performance and Scalable ASP.NET Websites Made Easy
Web Applications: N-Tier vs. N-Layer - Benefits and Trade-Offs
Query Analyzer - Sql Server Database Indexes and Execution Plans

Improving Application Performance in .Net

Application performance has always been a concern for Web Application developers. This article contains guidelines and tips for maximizing application performance in ASP.NET.

Tips to Improve Your ASP.NET Web site performance

ASP.NET has been developed with lots of features which makes developer life easy. Start from ViewState, PostBack, Server Controls , User Controls and etc. All of them can make your web development experience fun and easy, but improper use of them can cause your site performance slowdown. Most of the controls generate overhead to the client and server. Therefore in this article, I I will list out about things you can do and don't to improve your ASP.NET website performance.
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