When configuring Modeshape 5.4 to use a remote MySQL JDBC store for the repository I have noticed it takes a very log time to query the data.
Modeshape appears to be issuing thousands of sql select statements similar to the following:
SELECT CONTENT from MODESHAPE_REPOSITORY where ID = ?
This doesn't scale across the network. Are there any options to increase performance when using Modeshape with a remote database?
I have turned on various local indexes but that doesn't seem to reduce the number of queries to the database.
It would be helpful if someone could outline why Modeshape has to make all those individual SELECT queries and if there is a way to optimize Modeshape so it can perform across a remote persistent JDBC store.