IT Bookworm Blog

May 14 2009   5:00AM GMT

Tuning database applications for performance



Posted by: BrentSheets
Tags:
Data access
Database applications
Database performance
Database scalability
DB2
John Goodson
MySQL
Oracle
Prentice Hall
Robert A. Steward
SQL Server

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.

Signature
Community Manager

The Data Access Handbook Written by
Title

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

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

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

RELATED BLOGS
→ 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

RELATED RESOURCES
→ 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 SearchSOA.com
→ Visit the SearchWinDevelopment.com website
→ Visit the TheServerSide.com website
→ Visit the TheServerSide.NET website
→ Visit the SearchSOA.com website
→ Visit the SearchOracle.com website
→ Visit the SearchSQLServer.com website
→ Visit the SearchSoftwareQuality.com website
→ Visit the Ajaxian.com website

RELATED CONTENT
→ 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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: