Application Design for Performance and Availability

Monday, 27 June, 2005 - 14:15 - 15:15
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



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



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020