Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Programming, Performance Tuning, ADO, SQL Server 7 Rss

   Items 1 to 7 of 7   
 

Reducing Round Trips

One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.   Read more...
By Andy Warren 2005/07/15 (first published: 2002/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,859 reads

Introduction to ADO Part 2 - Recordsets

Part two in the Introduction to ADO series, this beginner level article shows how to open a recordset, how to add and edit records, and touches lightly on how to select the best cursor type and locking mode. Good code samples help you get started fast!   Read more...
By Andy Warren 2003/11/28 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 16,198 reads

Reducing Round Trips - Part 3

This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting.   Read more...
By Andy Warren 2002/03/11 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,853 reads

Performance Comparison: Data Access Techniques

Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.  Read more...
By Additional Articles 2002/03/01 | Source: Microsoft SQL Home | Category: performance tuning
Rating:  Rate this |   Briefcase | 2,405 reads

Reducing Round Trips - Part 2

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!   Read more...
By Andy Warren 2002/02/06 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,234 reads

Reducing Round Trips

One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.   Read more...
By Andy Warren 2005/07/15 (first published: 2002/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,859 reads

Taming the Stateless Beast: Managing Session State

Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.   Read more...
By Additional Articles 2001/07/06 | Source: Microsoft MSDN | Category: performance tuning
Rating:  Rate this |   Briefcase | 1,269 reads
   Items 1 to 7 of 7   
 
Tags
miscellaneous (3)    
visual basic 6 (3)    
t-sql (2)    
.net (1)    
asp (1)    
basics (1)    
database design (1)    
sql server 6.5 (1)    
xml (1)