The mdl_lmb_enrolments uses "TEXT" field types for many fields that do important queries. This prevents any indexes from being created to improve query performance. Consider changing fields like 'coursesourcedid' and 'personsourcedid' to an type that can be indexed, such as VARCHAR(255). Without this, large sites can have terrible performance.