I tried it on 'aurora' (AWS's supposedly 100% mysql compatible, 'up to 5x faster' db) and i got an error in how table names needed to be defined on a where clause on a databasejoin. i didn't notice any obvious performance gains but didn't do any scientific testing.
for example, this on the where data-where tab (to filter a databasejoin element that joins to jos_users.id):
WHERE {thistable}.id in (SELECT m.user_id FROM jos_user_usergroup_map m WHERE group_id = 11)
created an error:
500
Error: 500
Fabrik has generated an incorrect query for the list Properties:
Unknown column '#__users_0.name' in 'field list'
i tried:
WHERE .id in (SELECT m.user_id FROM jos_user_usergroup_map m WHERE group_id = 11)
and
WHERE jos_users.id in (SELECT m.user_id FROM jos_user_usergroup_map m WHERE group_id = 11)
THEN, i tried mysql 5.7 and got the same error. again, no scientific testing, but the admin panel and site seemed to be noticeably faster.
NOTE: last week one day, the WHERE i had been using above for years stopped working with this same error above. i had to change WHERE jos_users.id to WHERE {thistable}.id for it to work.
Never did figure that out, i suspect a fabrik update may have caused it to start working differently. but i can't get any of these options to work on MySql 5.7.
i moved back to 5.6 and the error went away.
but looks like there is something about mysql 5.7 and aurora that is different there.