IT Bookworm Blog

May 14 2009   5:00AM GMT

Tuning database applications for performance

BrentSheets Brent Sheets Profile: BrentSheets

Overview: “Performance and scalability are more critical than ever in today’s enterprise database applications, and traditional database tuning isn’t nearly enough to solve the performance problems you are likely to see in those applications. Nowadays, 75-95% of the time it takes to process a data request is typically spent in the database middleware. Today’s worst performance and scalability problems are generally caused by issues with networking, database drivers, the broader software/hardware environment, and inefficient coding of data requests. In The Data Access Handbook, two of the world’s leading experts on database access systematically address these issues, showing how to achieve remarkable improvements in performance of real-world database applications.

Drawing on their unsurpassed experience with every leading database system and database connectivity API, John Goodson and Rob Steward reveal the powerful ways middleware affects application performance and guide developers with designing and writing API code that will deliver superior performance in each leading environment. In addition to covering essential concepts and techniques that apply across database systems and APIs, they present many API examples for ODBC, JDBC, and ADO dot NET as well as database system examples for DB2, Microsoft SQL Server, MySQL, Oracle, and Sybase.”

This free chapter has been selected from The Data Access Handbook: Achieving optimal database application performance and scalability by Prentice Hall. Enjoy the chapter and be sure to check out the related database and development resources listed below. Voice your feedback on this chapter or let us know of other books you’d like to see featured on the IT Bookworm Blog by leaving a comment. Thanks.

Community Manager

The Data Access Handbook Written by

Published by
Published on
John Goodson and Robert A. Steward
The Data Access Handbook
Achieving Optimal Database Application Performance and Scalability
Prentice Hall
March 26, 2009

Download the chapter DOWNLOAD THE CHAPTER
Chapter 4: Tuning for performance

→ Visit our Development community
→ Need answers? Ask your own Database development question

→ Visit the .NET Developments blog
→ Visit the SQL Server with Mr. Denny blog
→ Visit the Eye on Oracle blog
→ Visit the Software Quality Insights blog
→ Visit the Custom Application Development blog
→ Visit the The Multifunctioning DBA blog

→ Browse .NET Framework database programming resources
→ Browse Data architecture for SOA resources
→ Browse Software performance, load and stress testing resources
→ Browse New and updated tutorials from
→ Visit the website
→ Visit the website
→ Visit the TheServerSide.NET website
→ Visit the website
→ Visit the website
→ Visit the website
→ Visit the website
→ Visit the website

→ IT Definitions: ODBC, JDBC and ADO (visit the Software Development Glossary for more)
→ Blog: Persevere’s JavaScriptDB: Impressive JSON Performance
→ Article: Componentized XML Query tool takes a step forward
→ Learning Guide: SOA Data Integration Tutorial
→ Quiz: SOA: What do you know?

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: