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. [...]
|
|||||
|
|
Last week I blogged about the rise in importance of location-based data. The timing was not a coincidence. I am a bit of a gadget freak and last week was a pretty important event in the world of gadgets and technology in general. For the first time ever Apple, a company specializing in mobile devices, became the largest technology company in the world, edging out Microsoft, a traditional computing company. Because pretty much every mobile device today comes with ability to capture location data, I am convinced that we are entering a stage where location data will become ubiquitous. [...] I don’t speak for IBM and I don’t express opinions of IBM if there ever was such a thing. I spend the last 25 years in the IT industry and I have to say that I have rarely seen such blatant disregard for the freedom of choice as Apple has done in its now infamous Clause 3.3.1 of the Apple iPhone OS SDK License. It reads like this: Applications may only use Documented APIs in the manner prescribed by Apple and must not use or call any private APIs. Applications must be originally written in Objective-C, C, C++, [...] I think that every Database Administrator needs to read the article “Opinion: No more excuses for SQL injection attacks” and send it out to every application developer they know. I hate SPAM as much as the next guy but I think it is justified in this case. I am dead serious. We, the database people of all walks of life (DB2, Oracle, SQL Server …), have been talking about the benefits of using parameters in the queries instead of literal values for years. The main message has been “performance”. Most DBMS will perform much better and will use [...] Our development team just released version 1.1.1 of the IBM_DB gem which provides support for using Ruby on Rails with DB2 and IDS. The new gem provides support for Activerecord 2.3.3 and a fix for a defect that will let us implement support for a popular Ruby on Rails application. [...] |
|
|||
|
Copyright © 2010 FreeDB2.com - All Rights Reserved |
|||||
