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 …
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 …
In the past year we have spent a lot of effort putting DB2 on the cloud and we achieved absolutely fantastic results. Db2 has proven to be a hit on both the Amazon cloud, on RightScale and on the IBM Developer Cloud. But all this focus on running applications on the rented IT infrastructure in the cloud does not mean we don’t care about people who want to have their own IT equipment. The free DB2 Express-C is a good fit for small and medium business and an even better fit for remote offices of very large enterprises. [...]
Read …