You can find this option by going to Table Builder > TABLE > Large Table Support. Enabling this improves performance for large tables.
What does large table support do? #
- Enables row count estimation
- Requires the user to press enter on search
- Sets pagination to compact
- Removes the last page pagination button
- Reduces network traffic and server load
An additional option to skip row counts appears when enabling large table support.
- Skips all SQL count statements.
- Can boost performance for large tables dramatically.
- Results in poorer user feedback.
Notes: #
- By default, the server decides to enable or disable large table support.
- A table reload (refresh page) is required after adjusting large table support settings to ensure the correct row count is applied.