On 2024/09/29 15:53:22 Raffaele Gambelli wrote: > Hi all, > > I'm testing my code either with jackrabbit 2.x on mariadb or oak on mongodb, > both with filedatastore. > > I've found executing benchmarks that oak with mongo is really slow compared > to jackrabbit, so I wanted test oak with mariadb, I'm not able to do it > working, when I try I see in logs: > ...
WRT testing with MongoDB - are you testing with a local MongoDB instance? Do you happen to know whether a specific test class is slow? (Note that when you test without a local test instance, a dockerized MongoDB is instantiated for every test, there maybe a JIRA ticket for that). As for testing with RDB instead - that won't be faster, as the RDB document essentially emulates the Mongo API. RDB support has been dormant for several years, so I'm not surprised that there may be problems (I've restarted testing with Apache Derby (embedded, see https://ci-builds.apache.org/job/Jackrabbit/job/jackrabbit-oak-trunk-derby-ibm-java21/) and PostgreSQL, with which most tests are passing right now). Re Mysql and MariaDB - these were added back then because they seemed to work just fine. I haven't tried since. The exception seems to indicate that MariaDBs limits for primary key size are a problem; maybe that can be fixed with additional config (of the DB or the tables). Best regards, Julian
