Some general tips when writing an SQL statement
One: only “tune” SQL after code is confirmed as working correctly
Two: code the query as simply as possible i.e. no unnecessary columns are selected, no unnecessary GROUP BY or ORDER BY.
Three: it is the same or faster to SELECT by actual column name(s). The larger the table the more likely the savings.
Use:
SELECT customer_id, [...]
Managing the WHERE Clause
The WHERE clause is the place to start your search for SQL you can change to get better performance. You already know what indexes you have. Now look at the optimizer plan for a problem query and see if the indexes are getting used or if the optimizer is searching the table row by row.
Why [...]
Put On Your Hard Hats, You Can Now Create 3D Buildings In Go…
Google is launching their version of Sim City today, Google Building Maker. The tool lets you create buildings for Google Earth. Building Maker lets you pick any building and construct a 3D version of it using photos and building blocks provided by Google. Google says that buildings are relatively fast to construct using their tool, [...]
Wi-Fi Sees Through Walls Edition
Discovery video below
Here’s a quick look at the news that hit our radar that didn’t quite make the front page today.