Re: Maria vs. DB2 performance on IBM i

Hi Jim,

As much as I am partial to the IBMDB2i storage engine... The Db2 storage
engine is great for all the obvious advantages that you listed in your
original post, but it's not likely to win a benchmark race against the
core storage engines in MariaDB (if nothing else, there is the overhead of
character conversion between CCSID 37 and UTF-8 on every I/O.) That said,
it should perform perfectly well for a "moderate to low used web site,"
and I suspect any performance difference between engines would be
indistinguishable to the end user. For what it's worth, migrating between
storage engines is usually not too difficult: a simple ALTER TABLE will do
the trick in most cases.

Hope that helps!
Tim Clark

date: Thu, 30 Jan 2020 11:36:03 -0600
from: <midrangel@xxxxxxxxxxxxxxxxx>
subject: Re: [WEB400] Maria vs. DB2 performance on IBM i

The native Maria storage engine, but your intuition question is exactly

what

I'm asking. Yes, I would ordinarily agree with you but, is it worth the
extra work to move the data?

--
Jim Oberholtzer
Agile Technology Architects