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:
CPU Model: Intel(R) Xeon(R) CPU E5-2696 v4 @ 2.20GHz
CPU Details: 8 Core (2197 MHz)
Distro Name: CentOS Linux release 7.8.2003 (Core)
Kernel Version: 3.10.0-1127.19.1.el7.x86_64
Ram: 16GB
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
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.
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
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