File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Are Antipatterns all performance killers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Are Antipatterns all performance killers" Watch "Are Antipatterns all performance killers" New topic
Author

Are Antipatterns all performance killers

Rob Ivan
Greenhorn

Joined: Jan 07, 2010
Posts: 28

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

Joined: Aug 02, 2010
Posts: 32
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.


Bill Karwin is the author of SQL Antipatterns: Avoiding the Pitfalls of Database Programming
Rob Ivan
Greenhorn

Joined: Jan 07, 2010
Posts: 28

Thank you, Bill. I look forward to reading your book.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Are Antipatterns all performance killers