.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

Does anybody know anything about converting search criteria to Binary to improve performance?

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
Does anybody know anything about converting search criteria to Binary to improve performance?
Mr Shaw

View Complete Post

More Related Resource Links

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.

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.

Best Coding Techniques To Improve Performance for SharePoint Applications

As more developers write custom code by using the SharePoint Object Model, they encounter common issues that can affect application performance.

The following areas reflect the main issues encountered by developers as they write custom code by using the SharePoint object model:

§ Disposing of SharePoint objects

§ Caching data and objects

§ Writing code that is scalable

Event Tracing: Improve Debugging And Performance Tuning With ETW


Event Tracing for Windows (ETW) provides general-purpose, high-speed tracing of events raised by both user-mode applications and kernel-mode device drivers. Learn how ETW can improve your development and debugging work.

Dr. Insung Park and Ricky Buch

MSDN Magazine April 2007

IIS 6.0: New Features Improve Your Web Server's Performance, Reliability, and Scalability


As the Web evolves, so does the role that Internet servers play. The Internet has seen the growth of e-commerce, B2B business, collaboration, streaming and other new media, and these new applications require new features to meet increasingly complex needs. Microsoft Internet Information Services (IIS) has many of the features today's mature Web sites need. This article outlines the features in the upcoming version 6.0 and discusses how they promote better scalability, reliability, and performance. Features such as Remote administration, caching, and metabase improvements, as well as custom isolation and security enhancements, make IIS 6.0 the Web server of the future.

George Shepherd

MSDN Magazine March 2002

Tip #107 Did you know . How to improve debugging performance for MVC2 application in Visual Studio 2

VS2010 Ultimate included IntelliTrace functionality by default.  IntelliTrace captures events (e.g. exceptions), and can affect performance of debugging. The typical performance hit is about 5% in the default mode (collection can be increased to...(read more)

How can I improve the performance of batch inserts with the JDBC driver?

In our testing, batch inserts are more than 4 times faster on Oracle with the Oracle JDBC driver than on SQL Server with either the Microsoft or jTDS JDBC drivers on the same hardware.  The issue appears to be with the JDBC driver, not the database server.  We have run tests with SQL Server 2005/2008 on a number of machines with similar results. The following code shows a simplified example of the code we are executing.  It uses a 2 column table which has an index on the id column.  In the test program we are inserting 100k rows with a batch size of 10k.  Any suggestions on improving the performance with the SQL Server JDBC driver?   private void testBatchInserts(Connection conn, int rows, int batchSize) throws SQLException {     String sql = "INSERT INTO Bench (id, name) VALUES (?, ?)";     conn.setAutoCommit(false);     PreparedStatement stmt = conn.prepareStatement(sql);     int batchCount = 0;     // For each row...     for (int i = 1; i <= rows; i++) {       // Create the record       stmt.setInt(1, i);       stmt.setString(2, "ROW #" + i);       // Add it to the batch       stmt.addBatch(); &nb

Looking for suggestions or ideas how to setup to capture search criteria and present to user if they

Requirements call for the ability to save search values so that they can select them at later times to return the results without having to re-enter the values. They have the ability to search on 4 different types of data (Date, Time and Lat/Long), so they would like to capture what was entered and ONLY if they chose to save those values, it will be saved and next time they login, if they are searching, they can pick an old search and submit it again.   Im thinking that i add a checkbox next to each button, if they check it, it saves the data into a table with there values and username. Next time they login and go tothe search page, if there are any records for them in the table, i present them with a link that displays all the values stored and if they select one, it will run the search again and present them with the results.. does that sound like the right way to handle this request? 

Multible search criteria with empty field option

I have a gridview with two textboxes (first name & last name) and a linkbutton to search results inside the gridview.I have made select parameters as well and the search works if i write in both textboxes. However, if I leave one textbox blank, i don't get any results.------------------------------First Name: <asp:TextBox ID="txtSearch_FName" Width="100px" runat="server"></asp:TextBox>&nbsp;&nbsp;&nbsp;Last Name: <asp:TextBox ID="txtSearch_LName" Width="100px" runat="server"></asp:TextBox> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:LinkButton ID="LinkButton1" Text="Find" runat="server" OnClientClick="return check();" /><asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="Searching" CellPadding="4" PageSize="15" GridLines="Vertical" onrowcreated="GridView1_RowCreated" Width="100%"><PagerSettings Mode="NumericFirstLast" /><HeaderStyle BackColor="#666666" /><AlternatingRowStyle BackColor="#f4f4f4" /><FooterStyle BackColor="#666666" />  &

improve performance

i have a problem about how to improve the performance because when i retrieve around 5 thouands record to datatable and bind to datagird, the speed is slow. but when i execute the sql in the sybase. the execute time is fast(reasonable) what is the probelm? how to improve the perforamce. 

How to improve performance

I have developed an application with two pages 'AddClient' and 'EditClient' and deployed it. It works fine but on the 'EditCient' page it takes about 8-9 seconds to populate clients information after a client has been selected from the DropDownList. I have around 40 controls, 5 update panels and a BingMap on this page. On Page Load I'm populating 8 DropDownLists from dataset and each DropDownLists has about 150 items. Clients DropDownList has about 6000 items. How can I improve the performance? Any help/ suggestions would be greatly appreciated..  

improve performance of gird on page index change


i am using data gridview asp.net  control and i bind it dynamically, gird displayed 80,000 thousands records so i am using paging techniques,on each page gird display 10 record so when i am change page each time gird should filled 80.000 thousands records so how could i bind gird from pageIndex,pageSize rather than bind it whole records

my code is below

BAL,DAL techniques so Method for data gird binding is following

private void FillGrdTendersDeptWise()
        tender objTdr = new tender();
            DataTable dt = new DataTable();
            dt = objTdr.GetAllTenderDeptWise();

            grdTender.DataSource = dt;

        catch { }

page index change

How to improve performance on an instance with large I/O activity?


I have a mirrored instance that throws up 'unsent log' and 'unrecovered log' errors. Everytime it does the I/O activity shoots up. I was wondering what can be done to improve this?

Extra memory? More processing power?

What if I spread the filegroups across different disks? Would this help?

How to improve performance on an instance with large I/O activity?


I have a mirrored instance that throws up 'unsent log' and 'unrecovered log' errors. Everytime it does the I/O activity shoots up. I was wondering what can be done to improve this?

Extra memory? More processing power?

What if I spread the filegroups across different disks? Would this help?

"secondary" search criteria


I have an asp.net web page that searches an SQL table based on a number of parameters, including city name (which is contained in a field called "City"). The results of this search are returned in a list of records grouped and ordered by city name.

Here's a random example of how the search results would be rendered on the web page:

  • New York:

    • record 1
    • record 2
    • record 3
  • Capetown:

    • record 4
    • record 5
    • record 6

This is working fine. But now I need to also include any records whose location is "nearby" the city. This is determined by 2 fields in the table, Alt_Locale1 and Alt_Locale2. For example, let's say that there's a record 7 which has "New York" as its "Alt_Locale1" value.

The results should look like this:

  • New York:

    • record 1
    • record 2
    • record 3
    • Nearby Results:

      • record 7
  • Capetown:

    • record 4
    • record 5
    • record 6

So, I need to revise my code behind to take the results of a query and check to see if the "City" values in any of the returned records match any values in "Alt_Locale1" and "Alt_Lo

Sharepoint Search Performance issue


Hi i am using Sharepoint 2007  Search and we are currently doing a performance test on the search. The issues is that once we add more concurrent users (more than 10) though the search results are displayed to the user  the CPU usage goes beyond the threshold value . Can any one tell me if there might be some thing which might be causing this. Some one else suggested that there migh be some services running on the server which are not actually required. But didnt mention which once specifically.  

Details of the share Point server :


·         OS                          :  Microsoft Windows server 2003

Need To create Stored Procedure for a Search Criteria


Hi all,

I need to create a stored procedure for a search criteria same as the linkedin.com is having with it under job search module. but i don't understand from where should i start. i am not getting any clue for that. please help.....

i am working on SQL Server 2005.

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