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. [...]
|
|||||
|
|
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. [...] If you spend any time in the fast growing Russian IT market there is one name you will no doubt be familiar with. I am not talking about Microsoft, Oracle, HP or even IBM. A company with a very short name “1C” is an icon of the Russian IT economy. Founded in 1991, 1C helped the newly formed Russian companies to get proper accounting and other financial management footing to be able to compete on the local markets and to enter and, in many cases, lead in the global economy. 1C is a major software distributor and an award winning game developer. If [...] Cloud based version of Microsoft Office 2010 is supposed to be a free offering. Will Microsoft really set Office free or will it cripple it like it did with SQL Server Express to protect revenue. [...] I recently blogged about Oracle killing one of its recent acquisitions a company called Virtual Iron. I posed a question if the same fate awaits MySQL. This proved to be a popular post and there was no shortage of comments. One particular comment identified what the person believes is a shortcoming of DB2: The way DB2 manages users — via the OS — is a large hurdle for people coming from MySql (or any other DBMS for what that matters). DB2 express will never flourish before they provide user management like MySql and MS Sql have. Brad Perkins [...] |
|
|||
|
Copyright © 2010 FreeDB2.com - All Rights Reserved |
|||||
