Title: Editing from SQL views doesn’t work.
Last modified: August 8, 2022

---

# Editing from SQL views doesn’t work.

 *  Resolved [unicamps2022](https://wordpress.org/support/users/unicamps2022/)
 * (@unicamps2022)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/editing-from-sql-views-doesnt-work/)
 * 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)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/editing-from-sql-views-doesnt-work/#post-15901042)
 * Hello there.
 * Since you’re using the Premium version of the plugin, please open a ticket on
   our [official support platform](https://tmsplugins.ticksy.com/), and we’ll gladly
   help you there.
 * Commercial products are [not supported in these forums](https://wordpress.org/support/guidelines/#do-not-post-about-commercial-products),
   as per [this comment](https://wordpress.org/support/topic/error-when-not-logged-into-wordpress-backend/#post-15050671)
   by WordPress.org moderators.
 * Thank you for understanding.

Viewing 1 replies (of 1 total)

The topic ‘Editing from SQL views doesn’t work.’ is closed to new replies.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

## Tags

 * [editing](https://wordpress.org/support/topic-tag/editing/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [views](https://wordpress.org/support/topic-tag/views/)

 * 2 replies
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [3 years, 10 months ago](https://wordpress.org/support/topic/editing-from-sql-views-doesnt-work/#post-15901042)
 * Status: resolved