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. [...] |
|
|||
|
Copyright © 2010 FreeDB2.com - All Rights Reserved |
|||||
