Return to previous page

Very slow search function - by john - on WordPress WooCommerce support

This topic has 30 replies, 4 voices, and was last updated 4 years, 3 months ago ago by John Holden

john

Participant

December 20, 2019 at 06:56

Hi, I have over 52000 products on the site and would very much like to speed up the search. Is there a way to turn off the autocomplete? It takes over 30 seconds of real time to return results. Is there a way to turn off the autocomplete?

#227199 Copied Theme version: 6.2.5 WooCommerce version: 3.9

29 Answers

john

Participant

December 20, 2019 at 07:02

I found out how to turn off the autocomplete (ajax) the search is still incredibly slow

#227200 Copied

john

Participant

December 20, 2019 at 07:12

Also the search doesn’t remove the “s” if some one types in blender bottles, and the sku search doesn’t do partial sku

#227201 Copied

john

Participant

December 20, 2019 at 07:24

AJAX Search uses like except for the search that uses the enter button. Searhc that uses enter button doesn’t use like it uses complete. Can this be adjusted?

#227202 Copied

Olga Barlow

Support staff

December 20, 2019 at 13:43

Hello,

1) Ajax results time depends on server response time and DataBase structure. Our theme does not have options to improve the results time because it’s related to how fast your server (DB) sends the response to requests made by theme. Try to improve the DB structure and speed up the server response time to get better results.

2) Search does not remove any symbols from the search request, how does it know when you want to remove “s” and when you don’t?

3) What do you mean by partial SKU? Could you provide examples from your site to check it?

Regards

#227255 Copied

john

Participant

December 23, 2019 at 04:37

Hi, Thanks for getting back to me. use the 3wcgc and type in each number slowly. Then when finished hit the enter button

#227385 Copied

john

Participant

December 23, 2019 at 05:22

The full product number is 62984-3WCGC and it doesn’t seem to work either

#227386 Copied

Olga Barlow

Support staff

December 23, 2019 at 10:47

Hello,

Try to create header using header builder https://youtu.be/RbdKjQrFnO4
Let me know if search by SKU works fine when header is created with header builder and when you use search element of the header builder. Keep in mind that the default header structures will be removed soon and the header builder will the main option to build header.
Or provide us with temporary Dashboard access to your site if you need help with header creation.

Regards

#227395 Copied

john

Participant

December 24, 2019 at 00:38

Using the header builder will speed up the search? While using the header builder is a small nightmare. Why is it that it doesn’t just adjust the current header to fit the new layout instead of forcing people to rebuild it?

#227440 Copied

john

Participant

December 24, 2019 at 00:40

Also using the header builder causes the wordpress menu locations to dissappear.

#227441 Copied

john

Participant

December 24, 2019 at 05:24

As far as I can tell the header builder doesn’t work right. I cannot get the menu to show up.

#227444 Copied

Olga Barlow

Support staff

December 24, 2019 at 06:50

Hello,

We have created Header Templates to allow users to import some basic structure and there is no need to start from the scratch.
Have you watched the video tutorials? Have you used main menu element and choose what menu to show in element settings? Could you please provide WP Dashboard access to your site to check and help you?

Regards

#227445 Copied

john

Participant

December 24, 2019 at 08:38

Here is the info you requested

Please contact administrator
for this information.

#227447 Copied

Olga Barlow

Support staff

December 24, 2019 at 12:16

Hello,

We have created header for you using the header builder. Check, please. Search by SKU works with a full SKU number http://prntscr.com/qf4lg9 and partial.

To speed up the search and your site:
1) Disable all the plugins that you don’t use. Every additional plugin slows down the site.
2) Use cache plugin (we installed W# total cache but you can choose any other you like)
3) Reduce the server response time
4) Make sure that DB structure is optimized.

Regards

#227454 Copied

john

Participant

December 29, 2019 at 07:43

Hi Olga,

The Search is not as it was prior. When the focus was on the search it would fill the screen horizontally. Also when I type in the first three characters the search doesn’t give any results. Now it only gives results when the enter button is pressed.

#227559 Copied

john

Participant

December 29, 2019 at 08:09

#227560 Copied

john

Participant

December 29, 2019 at 08:43

#227561 Copied

john

Participant

December 29, 2019 at 09:01

#227562 Copied

john

Participant

December 29, 2019 at 10:23

#227565 Copied

john

Participant

December 29, 2019 at 10:41

#227566 Copied
1 2

Viewing 20 results - 1 through 20 (of 30 total)