Limiting amount of data returned by a database to an application is probably the easiest and the most effective way to improve performance your application. DB2 provides 3 ways of accomplishing this. You can use DB2 SQL FETCH FIRST n ROWS syntax. You can use SQL syntax of another DBMS like MySQL, Oracle or Sybase, or you can do this in a database independent way by using the capabilities provided by the database API you are using in your application code. [...]
Read …
This really interesting article just crossed my desk. It looks like Oracle’s latest SEC filing is a pretty good indication of massive layoffs still coming as a result of the SUN acquisition. There is no way to tell which part of the business the layoffs will be in but I wonder if MySQL is affected. MySQL is not exactly a cash cow for Oracle and the business seems to be drying up as many loyal MySQL customers are heading for alternative sources of support for MySQL. It is not really cool or fiscally responsible to get support for [...]
Read …
Late night television has been almost a competitive and turbulent as database market of late. We have the whole Jay Leno vs. Conan O’Brien – The Tonight Show dilemma. Then there is Oprah Winfrey announcing end of her show. And then there is Charlie Sheen talking about quitting Two and a Half Men; now this one will hurt.
But I digress. Scott Hayes of Database-Brothers Inc. has decided to combine his love for databases and passion for good entertainment to start a DB2NightShow.com. The format is more like Tonight Show but there is no band. The jokes are [...]
Read …
This week I had an opportunity to spend some time at the annual MySQL conference in Santa Clara California. This is the second time I attended this conference. Last time I was at the MySQL conference was in the Spring of 2008 and the big news then was SUN acquisition of MySQL for a cool billion $s. This time it was Oracle swallowing SUN. So, when I was ready to go I was really curious to see how the conference would have changed and what the mood of the community would be.
Here are my highly subjective impressions. [...]
Read …
On Monday February 8th, without much pomp or ceremony IBM announced the new POWER7 microprocessor architecture and the 4 new SYSTEM p servers that utilize the new architecture. POWER7 is the next step in the IBM POWER roadmap and as far as next steps go it is a very significant one. I don’t intend to do a blow by blow account of everything that is new in POWER7 and what it really means. For those that are interested, I recommend attending one of the POWER 7 launch events/webcasts. If you are interested in databases (why else would you [...]
Read …