Re: Maria vs. DB2 performance on IBM i

Yea, the column names can wind up being a pain, I agree.

My sense of it is I'll leave it at this point.

--
Jim Oberholtzer
Agile Technology Architects

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

I have not used Maria with the Db2 storage engine Jim but did use the
storage engine with MySQL.

We were not that worried about performance so I didn't attempt to measure it
but I suspect there has to be some overhead in using it.

The bigger issue for me - because I _did_ have to use the same data with Db2
and RPG - was all the funky column names that resulted with many in quotes
because the MySQL table used some lower case names.

If I recall directly Brian May did some work in this area back then so he
may have some thoughts.

In summary though - if converting to Db2 in the PHP is an option I would do
it. For me I was using a package tool that did not support Db2 and in the
view of the software's developer it would have been a lot of work to switch.
So I have no choice but to use the Db2 engine.

On Jan 30, 2020, at 10:49 AM, midrangel@xxxxxxxxxxxxxxxxx wrote:

Folks:



Anyone have experience with Maria vs. DB2 (Maria using the DB2 engine)
on a moderate to low used web site (PHP)?

I am trying to decide with a newer web site if it's worth moving the
data into DB2 vs. leaving it in Maria.



The obvious recovery/backup, and access from IBM i traditional
programs notwithstanding, is there a compelling reason to move the data?



--

Jim Oberholtzer

Agile Technology Architects



--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400)
mailing list To post a message email: WEB400@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxxxxxxxx Before posting, please
take a moment to review the archives at
https://archive.midrange.com/web400.

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list To post a message email: WEB400@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxxxxxxxx Before posting, please take a
moment to review the archives at https://archive.midrange.com/web400.