Refactoring SQL Applications (污漬)

Stephane Faroult, Pascal L'Hermite

  • 出版商: O'Reilly|英文2書85折
  • 出版日期: 2008-09-30
  • 定價: $1,650
  • 售價: 5.0$825
  • 語言: 英文
  • 頁數: 298
  • 裝訂: Paperback
  • ISBN: 0596514972
  • ISBN-13: 9780596514976
  • 相關分類: SQLRefactoring
  • 立即出貨 (庫存 < 3)

買這商品的人也買了...

相關主題

商品描述

What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. Refactoring SQL Applications provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems. Learn to:
 

  • Determine if and where you can expect performance gains
  • Apply quick fixes, such as limiting calls to the database in stored functions and procedures
  • Refactor tasks, such as replacing application code by a stored procedure, or replacing iterative, procedural statements with sweeping SQL statements
  • Refactor flow by increasing parallelism and switching business-inducted processing from synchronous to asynchronous
  • Refactor design using schema extensions, regular views, materialized views, partitioning, and more
  • Compare before and after versions of a program to ensure you get the same results once you make modifications

Refactoring SQL Applications teaches you to recognize and assess code that needs refactoring, and to understand the crucial link between refactoring and performance. If and when your application bogs down, this book will help you get it back up to speed.

商品描述(中文翻譯)

當數據庫性能未達預期時,你可以做些什麼呢?在你考慮昂貴的硬體升級來解決問題之前,可以參考這本書。《Refactoring SQL Applications》提供了一系列經過測試的選項,可以通過修改程式碼來顯著改善數據庫應用的運行方式。通過真實世界的例子作為支持,你將找到簡單問題的快速解決方案,複雜情況的深入答案,以及對於存在大量問題的應用程序的完整解決方案。學習如下內容:

- 確定在哪裡可以期望性能提升
- 應用快速修復方法,例如限制對數據庫的調用在存儲函數和程序中
- 重構任務,例如用存儲過程替換應用程式代碼,或用全面的SQL語句替換迭代的程序語句
- 通過增加並行性和將業務處理從同步轉為異步,重構流程
- 通過使用模式擴展、常規視圖、物化視圖、分區等方式重構設計
- 比較修改前後的程式版本,以確保獲得相同的結果

《Refactoring SQL Applications》教你如何識別和評估需要重構的程式碼,並理解重構和性能之間的關鍵聯繫。當你的應用程序變得緩慢時,這本書將幫助你恢復其速度。