Over a million developers have joined DZone.

The Best of the Week (Mar. 28): SQL Zone

· Performance Zone

Evolve your approach to Application Performance Monitoring by adopting five best practices that are outlined and explored in this e-book, brought to you in partnership with BMC.

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (Mar. 28 to Apr. 3). Here they are, in order of popularity:

1. 6 Simple Performance Tips for SQL SELECT Statements

After years writing SQL statements, the author began to develop a mental check-list of things he looked at when trying to improve query performance. These are the things the author checks before moving on to query plans and reading the sometimes complicated documentation of the database he is working on.

2. The Power of Spreadsheets in a Reactive, RESTful API

The author has recently been deceived by his own Dilbertesque attitude when he stumbled upon a buzzword-filled article about Espresso Logic. But the actual product that claims to implement “reactive programming” through a REST and JSON API is frankly impressed by the ideas behind this product.

3. VoltDB Beyond Multi-Partition Transactions: Run Everywhere

VoltDB supports single- and multi-partition transactions. But what if you wanted to run an operation on all data (each partition), but you didn’t want to execute the operation as a multi-part transaction? Here’s how to do that.

4. Many-Table Joins in MySQL 5.6

I recently worked on an uncommon slow query: less than 100 rows were read and returned, the whole dataset fit in memory, but the query took several seconds to run. By default, MySQL 5.1 is not good at handling joins with such a large number of tables. The good news is that MySQL 5.6 brings improvements.

5. Installing PostgreSQL on Fedora

The author started the book Seven Databases in Seven Weeks in order to have better understanding of the different SQL / NoSQL paradigms. What are the pros and cons of each approach and play around with each type. In this post, he wants to share the installation process I had with PostgreSQL on Fedora.

Learn tips and best practices for optimizing your capacity management strategy with the Market Guide for Capacity Management, brought to you in partnership with BMC.


Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}