Ajax Search Lite Unusable

Hi!

Thank you for the details!

I did a few test searches, but I got results within 0.5-2 seconds, so this may point to an underlying issue somewhere on the server side. It depends on many many things though.

If this is something to do with the database, then try the Index WP MySQL For Speed, it is an amazing tool to generate additional indexes on database tables like the posts, post metadata, users etc.. It can yield a huge performance gain for your overall site as well as the queries, and may help with fragmentation issues as well.

If no luck, the please go to the Help & Support submenu under the Ajax Search Lite plugin menu on the back-end. You will find some information on how to share your configuration, so I can look for potential issues.

All the best,
Ernest

I am so sorry for such a late reply. I have been worknig on my 30/60/90 plan recently. However, i now have the login information to our WP back end and can continue these troubleshooting trials. One thing I have come to find out is that our website is using your plugin’s free version. This could very well be the issue. For us and all of our customers, it takes 30 seconds to maybe even 2-3 minutes per search. We do have several thousand products, which makes me think it could just be an issue with that we use the lite version.

Here is our debug data pasted into past.ee for your access: https://paste.ee/p/NbTM4#section0

If there is anything you would suggest to fix this issue, I would greatly appreciate it. I am new in this role and solving this would be a massive weight off my shoulders.

I appreciate your hands-on support as the creator of this plugin.

Thank you,

Luke Stephens

I hope we can find out if the plugin’s premium version would solve this issue before I get approval to add another plugin (Index WP MySQL For Speed) to our website. Either way, fixing this is one of my top priorities in the role. It is causing us to lose lots of potential sales.

I appreciate your continued help. If there is anything else I can offer you to assist with the troubleshooting, please let me know.

Additionally, I have just seen that you are out of the office until 9/4. I hope you enjoy your family vacation. Look forward to discussing this further! In the mean time, I have emailed this to you incase we cannot discuss it here.

(I have seen some tickets where you mention we cannot discuss paid plugins in these forums.)

• This reply was modified 1 year, 2 months ago by lukeest.

Thank you for the details Luke, I believe I answered your query about the pro version a few hours ago, if not, then I will get to it soon.

The configuration looks okay to me, I suspect the number of products + the search within the product contents might be a bit too much to handle for the database. I did a few tests and the search returned within 1.5 – 6 seconds every time, so right now it’s okayish.

First I suggest trying to turn off the search in the taxonomy terms, then the content, then the custom fields to see if there is any difference after each change. Those are probably the resource intensive query parts, depending on how much data there is, so if all goes well these changes should have impact on the performance.

All the best,
Ernest

Thanks for the response!

While the search function’s speed got fixed, we have a much more important issue that is causing our search queries to fail to read big commerce’s item_ID’s. I spent like 9 hours in customer support with WP Engine, and the only thing they can think it is is a database issue that has been around for a while (in search.php.) I know I was told the reason we downloaded ajax search lite originally was because our website’s default search function wouldnt work properly. Now, the WP Engine support tried everything as far as trying to restore several backups of the website and the search.php and other theme files that showed php error logs.

I really want to use Ajax Search, with quick results. When you search now, but dont hit enter (and let the Ajax live search qeue…), you can see that your plugin is able to pull the correct items. However, WordPress wont by default. Additionally, the override feature in Ajax Search Lite wont allow me to override the search results page.

Please, any insight here would be so helpful. I am new in this position, and this is the primary ‘task’ I have been given. I really don’t want to disappoint. I need to perform well in this task so that my capabilities shine, so to speak. Any advice or other information needed can be provided within minutes. Just let me know.

One last thing I’ll add is a Stackoverflow link to data I’ve compiled in this issue, as well as the actual PHP error log I see when search queries are running. Here are both stack overflow links, and here is the error log itself:

• PHP Warning: Attempt to read property “slug” on bool in /nas/content/live/sonictools/wp-content/plugins/bigcommerce/templates/admin/query-builder.php on line 68
• PHP Warning: Attempt to read property “term_id” on bool in /nas/content/live/sonictools/wp-content/plugins/bigcommerce/templates/admin/query-builder.php on line 67

I have now added WP extender, which brings back to big commerce products being searchable by SKU. I really dont know how it does this while ajax couldn’t; however i need any/all advice on using the two in unison. Your plugig is wha we use for the search shortcode in our header, so i dont want to get rid of it. I am trying to figure out the best way to pretty much only use ajax for the shortcode and for the live search on type. Having both causes a bit of lag, similiar to speeds when i originally reached. I just need to get back to instant speeds but while maintaining the accurate search results.

Thank you so much for bearing with me throughout all of these message the last couple of weeks.

Update: I have added WP extended search plugin and it has fixed this issue with the SKUs. It’s so fast, too. It works amazing now, i just have one more need. I really want to see a way to make the secondary sort function work. Maybe an advanced title or content field that would understand publish date? I just know that Ajax Search Lite’s secondary ordering by date descending does pickup. Any insight here is much appreciated!

This is why I need this… Look at our two example products. Product 1) “S10 Toolbox” and product 2) “drawer slide (s10)”. When someone searches ‘s10’ on the website, it shows a couple of dozen products that are considered accessories, like “paper holder grey (S10)”, are being classified as ‘more relevant’ than the product “S10 toolbox, 8 drawers”. I believe the latter is more relevant as the search term is the first word; however, that is not the case.

Okays!

By adding the other plugin it will very likely take control of the search results list on the results page – including the ordering. Try checking the settings in their plugin options, you may find a custom ordering feature, which may resolve that one remaining problem.

All the best,
Ernest