Application Design for Performance and Availability

Date: 
Monday, 27 June, 2005 - 14:15 - 15:15
Speaker: 
Susan Lawson

Today’s application environments demand more availability and high performance that we ever had in the past. One problem with achieving both of these is locking. Locking can hold resources that effects availability and can slow down performance. We will take a look at some things we can do to minimize this without compromising data integrity. We will also look at application availability issues, because if you are not available….you are not performing!

Locks and Lock Avoidance
 Bind Parameters
  Uncommitted Read
  Release Deallocate
  Current Data
 Lock Avoidance
  How it works
Application Design
 Designing for no deadlocks
 Restructuring code for maximum throughput
 Commit Strategies
 Index availability
 Cursor Usage

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023