How to Optimize Database in LearnPress version 3.2.8.4?

Optimize Database LearnPress

As you may know, LearnPress is a great free WordPress in LMS plugins. And, if you are using LearnPress Plugin, this is great news for you. In version 3.2.8.4 of our plugin LearnPress, we have added a new function: “Optimize Database” function in LearnPress => Tools => Database.

Optimize Database

As its name, this function helps you to reduce database system response time and improve the speed of some queries on your website such as load courses/orders in the backend, load course in frontend.

You only can see the difference when you have many data (courses) on your website.

For example, you have more than 1000 courses and you set to display 999 courses per page in the backend. We use the Page Load Time extension to display the loading time on this example.

Page Load Time extension

Before we optimize database, it takes 90s to load all courses when you access the course section in backend.

90s

After we optimized database, it reduces to 25s to load all courses.

25s

You should optimize the database to improve the experience on your website.

Read more: Frontend Editor add-on for LearnPress