Ajax Search Pro ist to slow for me

[ReudigaParticipant]

Hi, i bought your Ajax Search Pro on Codecanyon after you told me in the comments, that it is possible to use for many posts.

Know i tried to using it but its not fast. Its really really slow and not usable for me.

Any Ideas what i can do? I also tried to use index table but this is never ending with loading.
Current status after two weeks: Stats (reloads periodically) | Items Indexed: 284005 | Items not indexed: 123140 | Total keywords: 4658421

But doesnt matter cause the posts can be updated every few seconds.
On Codecanyon you said to me, that so many posts are not a problem…

So what can i do now?
I tried different things from your documentation but nothing helps right now.

Did you have any exact ideas?

[Ernest MarcinkoKeymaster]

Hi,

Index table is definitely the way to go. Indexing over 400 000 items will take a lot of hours. The number of keywords seems to be okay to me. It is also possible that the stats may not load from time to time, so just keep the indexing running until it finishes.

For that amount of content I highly suggest only indexing the most neccessary fields, as it will generate more than enough data to search. In your case probably indexing the post titles is more than enough: https://i.imgur.com/s3axyhD.png
Contents and excerpts may contain a lot of data, and for that amount of items the user will definitely get enough results for any search phrase.

Once the indexing is finished, you have to make sure the index table is enabled.

The rest is up to the underlying server performance and configuration. Make sure the server is on par with the amount of information, there is enough CPU and RAM, and if so, that the PHP has enough memory limit to perform the tasks. Querying such a large database for WordPress will take a lot more CPU and memory in general.

I also strongly suggest using this plugin to run an index query optimization on the database. It is super useful for generally big databases to make some very common queries much faster.

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[ReudigaParticipant]

Hi,

a few hours? Its loading for two Weeks now… So it looks like never finishing…

I also have everything disabled, only index titles and categories is active, cause that are filters/search fields.

I also already have that WP Index Plugin active.

So i have everything that you told me active. The Server has EPYC 7702 10 cores, 32GB RAM with 1TB SSD. So i think more than enaugh?

I dont know what i can do next… :/ Probably you want to see the settings inside or so? The Index table is indexing for two weeks and its never ending..

[Ernest MarcinkoKeymaster]

The server is definitely okay with that configuration, for that amount of data even 1 dedicated core is more than sufficient. We have tested on a single core server with about 3 million rows and it was perfectly fine. The bottleneck might be something else.

Have you kept the indexing window open until it finished? While the indexing continues in a backround task a wp-cron job, but that is nowhere near as fast (and it is not as efficient as a regular cron job) as keeping the tab open until it finishes.

If you want, you can add temporary FTP and back-end details, and I will take a performance test and debug.

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[Author]

Posts