Database size & speed

[dantwah]

Hello, Our site is running pretty big now, and I'm looking on how to optimize the DB, so that we can increase site speed. We currently have +- 2 milion postmeta items, which is increasing every day. Partially as I can see this is due to the fact that Every user that follows a course is put into a post-meta field. Is there a way to optimize this, so that in an updated version the people linked to the course are in 1 field, not in 1000+ seperate fields? Or any other suggestion to make sure we can scale it to the max :D. Thanks,

[Mark Morgan]

Hi @dantwah When a user follows a course there is only one meta field is added in database which includes  marks, expiry time and status only. After this meta field is updated,, so only one field is created for one user.  

[SuperDave]

Please can someone advise on how to scale back the growing metadata issue on our site.

[Veronica]

We have a planned feature request called "Archive users". Which is basically archive user and its data from active database, so that it is not taken into account for mysql calculations. Do you think this fits your issue as well ? the tables which will reflect with this are: wp_users wp_usermets wp_postmeta wp_commentmeta

[MeesterGijs]

This sounds great. When will this be available?

[Veronica]

may be with the wplms 4.0 if not then in next update after that.

[MeesterGijs]

Hi Veronica, Thanks for your answer. Any idea when that will be? Before May?

[Veronica]

not fixed! but maybe. as you know about the circumstances all around the world. we are also serving from ours' houses. so the development become little bit slow. we hope for the best. we always trying to give you best from our side. we all can only have patience! #staysafe

[MeesterGijs]

Totally understand. Luckily you and I can still do our work and get our income, right? Stay safe and I'll be patiently waiting :)   closing

[Veronica]

yes we are also continuing to our work and will get our income. thanks for your confirmation. closed.

[Author]

Posts