Custom Database Table

  • Resolved David Levine

    (@justlevine)


    6 years, 10 months ago

    Has ModernTribe considered (or have future plans), to migrate Event Calendar cpts (events, venues, organizers) to a custom Database table?

    The clear benefit would be scalability. In dev tests (I a site created 15 events under 3 venues and 2 organizers, and then duplicated the base structure for each using 3 Pods APTs), the database query went from .387ms to .00742. And on my live site, with ‘just’ 300 events, and an assortment of posts and pages I’m definitely feeling the slowdown on all wp queries.

    A custom table would get rid of all the extra metaata rows, that currentlty impact every query on the site, TEC specific or not
    Pods approach specifically means that each cpt only has one row in wp_post (basically a postid and then the link to the custom table info). It’s also the direction many other transformative plugins are going: woo and EDD, geodirectory, and more.

    Would love to hear your thoughts on the matter (and if you’re on board, maybe even consider submitting a PR – we’ve been looking for ways to give back to the project).

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hey there @justlevine,

    Thanks for reaching out!

    That’s pretty cool that you were able to get the query time down! I’ll pass on your idea to someone that would be more suited. You could also head over to our feature/idea page and submit your idea there → https://tribe.uservoice.com/forums/195723-feature-ideas

    Take care,
    Ed ??

    Thread Starter David Levine

    (@justlevine)

    Thanks for the quick reply @erishel !

    Did what you suggested. Link is here https://tribe.uservoice.com/forums/195723-feature-ideas/suggestions/34097266-speed-up-tec-and-improve-scalability-by-migrating

    • This reply was modified 6 years, 10 months ago by David Levine.

    I’m lead dev on Pods, but I’m excited that as part of the Modern Tribe / TEC team I’ve helped out with some good performance boosts. Tables is something we are working on, but I’ve also been working on some cool stuff that goes beyond MySQL using Elasticsearch. I can’t say what the release plan is for that, but it’s actively being used as part of our internal products.

    So glad you have played with performance on your side, I bet we have solved quite a number of the issues you’ve found so far with the Elasticsearch stuff that beats MySQL at large data amounts. I know we have tables on our roadmap but not sure on priority.

    I’m sure the team will reply on your Idea post with some better steps forward.

    Thread Starter David Levine

    (@justlevine)

    Really exciting news ??
    Keep up the amazing work @sc0ttkclark (on both plugins)!

    As a total aside (perhaps I should open a new topic), I use TEC on the nonprofit license, and the plug-in has literally changed everything about how we empower our community. Beyond leaving feedback on ideas, and a kudos on our calendar page, are theres other ways for us to give back – e.g. prs to the GitHub, and if so what’s the best way to get started?

    If you’d like to give back to TEC, consider helping create integrations with your favorite plugins. Outside of that, if you find bugs, create PRs that fix them. If you wanted to work on features/enhancements, that’s more tricky since we may already be working on those and step on each others feet ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Custom Database Table’ is closed to new replies.