Re: Maria vs. DB2 performance on IBM i

[Richard Schoen <richard@xxxxxxxxxxxxxxxxx>]

If the MariaDb database is working fine I would not suggest moving it in to DB2 storage engine unless you want to use the same data from an RPG application. 

I can't imagine the performance would really be noticed on a small site unless you just want to do it as a technical exercise.

I haven't run in to any customers using the native DB2 engine and don't know how much if any effort is still going in to it. 

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------

message: 6
date: Fri, 31 Jan 2020 08:10:25 -0600
from: <midrangel@xxxxxxxxxxxxxxxxx>
subject: Re: [WEB400] Maria vs. DB2 performance on IBM i

Yes default, which I believe is innodb.  

--
Jim Oberholtzer
Agile Technology Architects

-----Original Message-----
From: WEB400 <web400-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Nathan Andelin
Sent: Thursday, January 30, 2020 11:52 AM
To: Web Enabling the IBM i (AS/400 and iSeries) <web400@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WEB400] Maria vs. DB2 performance on IBM i

I've never heard of a "native" storage engine for MariaDB. Do you mean the "default" storage engine, which is supposedly https://mariadb.com/kb/en/innodb/? Actually, I'm not sure what the default storage engine is for PHP on IBM i. The phpMyAdmin dialog for creating tables has a drop-down list of about eight possible storage engine options.



On Thu, Jan 30, 2020 at 10:36 AM <midrangel@xxxxxxxxxxxxxxxxx> wrote:

> 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
>
> -----Original Message-----
> From: WEB400 <web400-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Nathan 
> Andelin
> Sent: Thursday, January 30, 2020 11:20 AM
> To: Web Enabling the IBM i (AS/400 and iSeries) 
> <web400@xxxxxxxxxxxxxxxxxx
> >
> Subject: Re: [WEB400] Maria vs. DB2 performance on IBM i
>
> On Thu, Jan 30, 2020 at 8:50 AM <midrangel@xxxxxxxxxxxxxxxxx> wrote:
>
> > I am trying to decide with a newer web site if it's worth moving the 
> > data into DB2 vs. leaving it in Maria.
>
>
> When you say "leaving it in Maria", what storage engine are you 
> referring to (i.e. MyISAM, InnoDB, CSV)? My intuition says that using 
> the IBMDB2i storage engine would perform better than a storage engine 
> that referenced a bulk IFS file. But I haven't seen any benchmarks to 
> prove it.
> --