Editing from SQL views doesn’t work.

  • Resolved unicamps2022

    (@unicamps2022)


    2 years, 3 months ago

    I have a single MySQL table containing over 15 million records.

    In WpDataTables, if I create a table from that large of a table with a standard SELECT query, it takes forever to load. Even if I pre-filter is with a WHERE clause to retrieve a dataset of only 200k records, the table still takes forever to load.

    However, if I first create a MySQL view for the pre-filtered 200k data set, then create a WpDataTables table based on that view, it loads instantly.

    But here is the problem…

    When I create the table based on the view, it’s much faster, but editing doesn’t work. Inline editing don’t work. I double click the field and the pop-up doesn’t let me select the value I want. And if I try to open the form to edit the field, it won’t save. The edit modal just doesn’t go away after clicking “ok”.

    Am I doing something wrong? Or is it a known bug?

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Editing from SQL views doesn’t work.’ is closed to new replies.