As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
Hi Team
I have trouble searching for heavy data of about 10 million records and 4 columns that are done in just one search column
It takes about 20 seconds to search!
Even when I use the Server-side processing (Lazy Loading) explained feature, the search time does not change even for 1 second !!
I did this test on the latest version of the plugin
server specifications:
WP Version: 5.5.1
PHP Memory Limit: 6 GB
PHP Version: 7.3.6
PHP Post Max Size: 12 MB
PHP Time Limit: 600
MySQL Version: 5.5.5
Do you have an idea to make searching for heavy data faster?
Because there is no problem with resources and servers and there is no load on the server
Sorry For Weak English
BR
Hello Sina
Unfortunately, as indicated in our documentation, this behavior is expected:
This may slow down the processing, search, filtering and sorting (of smaller tables also), but for larger tables it may be the only option.
The plugin has to go through all 10 million records in order to find the data you're searching for. Unfortunately, there's no workaround for this. Our development team will try and increase performance in the future, but I cannot say when it will be included in the plugin.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks for Response dear Aleksandar
I hope in the near future there will be a significant improvement in search speed
Because one of the most important features of this plugin should be high search speed.
We look forward to an exciting update in the future
BR
I couldn't agree more, Sina.
We have big plans for the next year, so I hope we'll be able to meet the expectations.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables