Open JesKingDev opened 1 year ago
As the cron_schedule table grows before it is cleaned, the performance of the getJobsByStatus call degrades due to a missing table index.
cron_schedule
getJobsByStatus
Resolves https://github.com/magemojo/m2-ce-cron/issues/134
Prior to pulling this down, run the following SQL against your db and notice that no index is used.
After installing, run the same query
Overview
As the
cron_scheduletable grows before it is cleaned, the performance of thegetJobsByStatuscall degrades due to a missing table index.Resolves https://github.com/magemojo/m2-ce-cron/issues/134
Testing
Prior to pulling this down, run the following SQL against your db and notice that no index is used.
After installing, run the same query