Any comparison Read/write SAM file vs DB2 ?

Billy Larsen

Any comparison Read/write SAM file vs DB2 ?
Dear all,

We all know that read/write are much more faster then select/insert. Does
any one has some measurements on this ? (SAM or VSAM )

I always tell my developers about this , but would be interested to know
what is the ration.

thanks

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Randy Dingman

Re: Any comparison Read/write SAM file vs DB2 ?
(in response to Billy Larsen)
While it may take more resources to perform DB2 selects or inserts, it is
somewhat like comparing apples to oranges. In terms of speed realized by
many applications, DB2 may appear to be significantly faster due to it's
many asynchronous capabilities.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Billy Larsen
Sent: Friday, January 07, 2005 11:05 AM
To: [login to unmask email]
Subject: [DB2-L] Any comparison Read/write SAM file vs DB2 ?


Dear all,

We all know that read/write are much more faster then select/insert. Does
any one has some measurements on this ? (SAM or VSAM )

I always tell my developers about this , but would be interested to know
what is the ration.

thanks

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm