The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability
Date: 27 April 2011, 12:41
|
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.NET as well as database system examples for DB2, Microsoft SQL Server, MySQL, Oracle, and Sybase. Coverage includes Clearly understanding how each component of database middleware can impact performance and scalability Writing database applications to reduce network traffic, limit disk I/O, optimize application-to-driver interaction, and simplify queries—including examples for ODBC, JDBC, and ADO.NET Managing connections, transactions, and SQL statement execution more efficiently Making the most of connection and statement pooling Writing good benchmarks to predict your application’s performance Systematically resolving performance problems—including eight start-to-finish case-study examples
|
DISCLAIMER:
This site does not store The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability on its server. We only index and link to The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability provided by other sites. Please contact the content providers to delete The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability if any and email us, we'll remove relevant links or contents immediately.