Title: Server-Side Processing Search Functionality
Last modified: January 15, 2024

---

# Server-Side Processing Search Functionality

 *  Resolved [gwolfalias](https://wordpress.org/support/users/gwolfalias/)
 * (@gwolfalias)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/server-side-processing-search-functionality/)
 * Hello there,
 * I am looking for some help in relation to the search functionality within a WpDataTable
   while the server side processing functionality is enabled. I am aware that the
   server-side processing is activated when a table is pass a certain amount of 
   rows, which is the case in this scenario. I read elsewhere that you should simplify
   the query as much as possible so that the dynamic creation of the new queries
   is not affected. We are pulling from a SQL server with a view via this query:
 * SELECT * FROM XXXXXXXXXXXXXX.dbo.vccAdapterLog
 * The search functionality was operating fine before the table got to such a size
   that the server-side processing was triggered, and now there are no matching 
   records being returned in the table when a search is attempted. Is there something
   on the server side that needs to be configured in order to allow for server-side
   processing, or a setting within WpDataTables that would need to be configured
   differently for this? Any help in relation to this issue would be greatly appreciated.

Viewing 1 replies (of 1 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/server-side-processing-search-functionality/#post-17348934)
 * Hello,
 * Since you’re using the Premium version of the plugin, please open a ticket on
   our [main Support platform here](https://tmsplugins.ticksy.com/),
 *  and one of our Agents will respond as quickly as possible.
 * Premium products are not supported in these forums, 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. 
 * Kind regards.

Viewing 1 replies (of 1 total)

The topic ‘Server-Side Processing Search Functionality’ 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

 * [search function](https://wordpress.org/support/topic-tag/search-function/)
 * [SQL Server](https://wordpress.org/support/topic-tag/sql-server/)

 * 2 replies
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [2 years, 4 months ago](https://wordpress.org/support/topic/server-side-processing-search-functionality/#post-17348934)
 * Status: resolved