Skip estimated row counts #
- All table rows
- All matching table rows
These counts consume resources and may slow down performance.
~Showing 1 to 10 of 12,565,527 entriesWith a filter:
~Showing 1 to 10 of 7017 entries (filtered from 12,565,527 total entries)The estimated row count feature only eliminates the first row count mentioned earlier. The second row count (with filter) is still needed to show the number of entries (see information summary above). Unfortunately, this is mostly the most resource consuming query of all.
Data Tables supports option wpda_use_estimates_only to prevent this query as well. This option elimates the second large table horror count at the cost of incomplete summary information. As a result, queries on a table containing > 12.5 millions rows are lightning fast, even with a filter. But the summary information always shows:
~Showing 1 to 10 of 12,565,527 entriesAnd does not contain the number of rows filtered.
The following advance table setting will force the plugin to use only estimates
{ "wpda_use_estimates_only": true }
