Follow me on TwitterLimiting 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. [...]
|
|||||
|
|
You can wait and see if Oracle will put MySQL on death row like it just did with Virtual Iron, or you can get ahead of the curve and start to plan for the alternatives like getting in touch with alternative MySQL support providers or take a look at DB2 Express-C and see if that is the right way for you to go. [...] I spent the last week in Portland at the O’Reilly Open Source Convention also known as OSCON. We were part of the IBM exhibit talking to people about DB2 Express-C. OSCON is an interesting conference. Basically it is a big lovefest for the open source guys. Imagine about 2500 geeks all assembled in a single place for a week to talk about free software. The best part for me is that OSCON is not fixated on Linux. There were plenty of tutorials and talks on PHP, Python, Django, Ruby on Rails and of course databases. As one would [...] |
|
|||
|
Copyright © 2010 FreeDB2.com - All Rights Reserved |
|||||
