Thread: interesting article: Leverage your PostgreSQL V8.1 skills to learn DB2, Version
interesting article: Leverage your PostgreSQL V8.1 skills to learn DB2, Version
From
"Pavel Stehule"
Date:
Hello, I found maybe interesting article http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0603wasserman2/ good days Pavel Stehule _________________________________________________________________ Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. http://www.msn.cz/
Re: interesting article: Leverage your PostgreSQL V8.1 skills to learn DB2, Version
From
mark@mark.mielke.cc
Date:
On Sat, Aug 05, 2006 at 10:01:30AM +0200, Pavel Stehule wrote: > I found maybe interesting article > http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0603wasserman2/ That for the article. I had been meaning to look at DB2, and it gave me a quick summary. What I get from the article, though, is that DB2 is more modularized than PostgreSQL, however, it has concurrency issues. Is this true? Anybody allowed to comment on the peformance of small-sized (~1 million rows) databases? I'm not seeing a compelling reason to switch. Cheers, mark -- mark@mielke.cc / markm@ncf.ca / markm@nortel.com __________________________ . . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder |\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ | | | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada One ring to rule them all, one ring to find them, one ring to bring them all and in the darkness bindthem... http://mark.mielke.cc/
Re: interesting article: Leverage your PostgreSQL V8.1 skills to learn DB2, Version
From
"Jim C. Nasby"
Date:
On Sat, Aug 05, 2006 at 08:42:23AM -0400, mark@mark.mielke.cc wrote: > On Sat, Aug 05, 2006 at 10:01:30AM +0200, Pavel Stehule wrote: > > I found maybe interesting article > > http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0603wasserman2/ > > That for the article. I had been meaning to look at DB2, and it gave me a > quick summary. > > What I get from the article, though, is that DB2 is more modularized than > PostgreSQL, however, it has concurrency issues. Is this true? Anybody allowed > to comment on the peformance of small-sized (~1 million rows) databases? > > I'm not seeing a compelling reason to switch. Unless it's changed recently, it uses shared read locks, so yes, there's definately concurrency issues to think about. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461