Choose table from web page

  • Resolved nonsolidice

    (@nonsolidice)


    3 years, 10 months ago

    I have created a single table with 15 million records in a MySQL back end. When creating a table, it was too slow. It would take about 20 to 30 seconds for a single search to return results. My back end is optimized. I concluded that I needed to split my large table into many smaller tables. I did this and now searching a table takes less than one second.

    My question is this…

    How can I create a single web page where when opened, the first thing that is on the page is a drop down selector populated with a bunch of custom labeled items that when I select one option, it pulls up the correct table I wish to search?

    I have attempted to look though many different forums and Google search, but I can’t find a solution. Please help.

Viewing 1 replies (of 1 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    3 years, 10 months ago

    Hello there,

    Thank you for reaching out to us.

    Unfortunately, something like this is not possible with the plugin’s built-in features.

    Tables are added to the page using shortcodes, and therefore the tables have to be loaded once that page is loaded. There’s no way to call the table based on a selection from a drop-down or a menu item. Maybe you could create a landing page where users would be able to click on an item and that leads them to a page where the needed table is loaded?

    You would need to create multiple pages and create hyperlinks on that landing page, though.

    You can also take a look at our filters and hooks and see if those would be of use to you, to create a custom functionality that would achieve something similar.

    Please note, though, that this requires coding skills and is not included in the provided support for the plugin.

    Kind regards.

Viewing 1 replies (of 1 total)

The topic ‘Choose table from web page’ is closed to new replies.