Re: 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.