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 …
The next DB2Night Show episode on Friday December 4 (10am Central) will be a no holds barred comparison of the IBM DB2 Express-C and Microsoft SQL Server Express and we will throw in Oracle XE for good measure. We will also talk about Cloud Computing and its impact on database professionals. This is a must see episode so register now. [...]
Read …