Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Are Antipatterns all performance killers

 
Rob Ivan
Greenhorn
Posts: 29
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are the SQL antipatterns to be avoided mostly for performance reasons, or are there other considerations (e.g., inaccurate results)?
 
Bill Karwin
author
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rob,

I touch on performance in a few chapters of "SQL Antipatterns," but mostly the problems have to do with broken database design, inaccurate results, inexplicable errors, poor development practices, or security holes.

Performance optimization is highly implementation-dependent, and I wanted to try to make my book as neutral as possible with respect to the SQL language, not cover tips & tricks of individual RDBMS vendors' implementations. There are plenty of books on Oracle Optimization, MySQL Optimization, SQL Server Optimization, etc.
 
Rob Ivan
Greenhorn
Posts: 29
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you, Bill. I look forward to reading your book.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic