Okay
  Public Ticket #2667094
Database tables
Closed

Comments

  •  3
    Matthew Gerrish started the conversation

    Our Services tab crashed again as it maxed out memory, most likely due to this. I'm not an expert but I think you are asking it to query too much...and this leads to 500 errors sometimes on admin-ajax:

    /wp-admin/admin-ajax.php?action=wpamelia_api&call=/entities&types[]=employees&types[]=appointments&types[]=categories&types[]=packages&types[]=locations&types[]=settings

    I was wondering why you have to add so many tables in the database.. I count 47 (see attached)!! 

     Im not a database expert but surely there is a more efficient way of setting up the db than this? I've never seen a plugin do anything like this before. What's the reason for such bloat?! Do you have any plans to recalibrate the impact your plugin has on the WP database? I expect leaner querying from a premium Enterprise-level plugin, if I'm totally honest... 

  •  2,572
    Aleksandar replied

    Hello Matthew

    Those database tables are required for relations in the plugin. However, that doesn't have anything to do with your memory limit, and it doesn't impact the speed of the form. You can create up to 2,147,483,647 tables in a database, with up to 1024 columns in each table, so 47 tables coming from Amelia can't impact your website.

    Amelia's form usually tries to allocate around 10KB while booking, but if it can't do that, it implies there's something else draining memory from your website.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables