Live from TSSJS – PostgreSQL with Tom

Main menu:

Topics

Recent Posts

Feeds

RSS Feed RSS - Posts

November 2017
M T W T F S S
« Oct    
 12345
6789101112
13141516171819
20212223242526
27282930  

Past Posts

Java/Java EE

JDBC

Other

Archive for the tag "mysql"

Live from TSSJS – PostgreSQL with Tom

March 17th, 2011 by Scott Selikoff

Live blogging from TheServerSide Java Symposium with┬áTom Kincaid at his vendor presentation “Introduction to PostgreSQL for Development and Deployment”. ┬áTom spends a lot of time contrasing Postgres with MySQL, and commenting how since Oracle’s aquisition of MySQL, the licensing of MySQL is now much more restrictive. Tom says the licensing of Postgres is basically “Do […]

Memo: Avoid Functions in Database Queries

October 21st, 2010 by Scott Selikoff

The most common type of questions in the JavaRanch JDBC forum tends to be about improving performance in a database (that, and “Where can I download a JDBC Driver?”). While remote trouble-shooting performance issues can be tricky, we often spot issues with the presented queries and offer alternatives to improve performance. One issue I see […]

Memo: Avoid Nested Queries in MySQL at all costs

December 10th, 2008 by Scott Selikoff

Some of my readers may be aware that nested subqueries such as “SELECT * FROM widgets WHERE id IN (SELECT …)”, don’t work all that well in MYSQL. While the syntax is usually correct, the performance issues in practice can be horrendous. This article delves deeper into this issue, and why MySQL performs so poorly […]