I have been using your wplms for more than 7 years. I have more than 100K users with more than 40+ courses.
* at the begining I have activate messages, notifications, friend, activity etc and due to this feature activation my site database become more than 8GB. as it's run on mysql, it's now become challenging for me to maintain this huge database most of the time site become down (showing error establishing database connections) due to this huge data query.
* I have deactivated friend connections, message, notifications and other unnecessary features but still site generate huge unnecessary data and make my site slow and although I'm using dedicated server but still site become very slow because of data and connectivity.
* I'm still using your old version 3.9 user interface with batch plugins, I have tried more than 100 times to migrate to 4.x version but there is showing huge bugs, so I can't able to migrate to 4.x version
** *** MY SITE BECOME DOWN 4/5 TIMES EVERYDAY DUE TO THIS HUGE DATABASE SIZE AND OLD VERSION.****
please MR Alex make a consultant with me give me a proper solution.
I have already working with a custom lms with MERN but It will still take one year to complete. So I need a proper solution during this time to use your lms.
I fully understand your concern, this is one of the challenges we face with WordPress. The activity table and the meta tables ( user + post) are the ones heavily used. For one of our users, a temporary solution was to identify users who did not log in for past 2 years and remove their data. This has to be done on a case to site basis on how much data you're willing to lose.
--
In version 4, you can actually split the API calls under multiple wordpress instances, so Course A - A100 can be on server 1 whereas Course B-CourseB100 on server 2 both with WPLMS and it provided a multi-tenant architechture for a huge site and splitting the load across multiple servers.
We are also working on a solution with Supabase + nextjs for upcoming SAAS version of WPLMS but our estimate alpha release is Jan'24. The best part is that we are building a data migration tool, so all the data can be as it is used in the SAAS.
Hi,
I have been using your wplms for more than 7 years. I have more than 100K users with more than 40+ courses.
* at the begining I have activate messages, notifications, friend, activity etc and due to this feature activation my site database become more than 8GB. as it's run on mysql, it's now become challenging for me to maintain this huge database most of the time site become down (showing error establishing database connections) due to this huge data query.
* I have deactivated friend connections, message, notifications and other unnecessary features but still site generate huge unnecessary data and make my site slow and although I'm using dedicated server but still site become very slow because of data and connectivity.
* I'm still using your old version 3.9 user interface with batch plugins, I have tried more than 100 times to migrate to 4.x version but there is showing huge bugs, so I can't able to migrate to 4.x version
** *** MY SITE BECOME DOWN 4/5 TIMES EVERYDAY DUE TO THIS HUGE DATABASE SIZE AND OLD VERSION.****
please MR Alex make a consultant with me give me a proper solution.
I have already working with a custom lms with MERN but It will still take one year to complete. So I need a proper solution during this time to use your lms.
thank you.
I fully understand your concern, this is one of the challenges we face with WordPress. The activity table and the meta tables ( user + post) are the ones heavily used. For one of our users, a temporary solution was to identify users who did not log in for past 2 years and remove their data. This has to be done on a case to site basis on how much data you're willing to lose.
--
In version 4, you can actually split the API calls under multiple wordpress instances, so Course A - A100 can be on server 1 whereas Course B-CourseB100 on server 2 both with WPLMS and it provided a multi-tenant architechture for a huge site and splitting the load across multiple servers.
We are also working on a solution with Supabase + nextjs for upcoming SAAS version of WPLMS but our estimate alpha release is Jan'24. The best part is that we are building a data migration tool, so all the data can be as it is used in the SAAS.