[Resolved] Search Engine working very slow

[Author]

Posts

[linaS]

First of all the Url is: hidden link
* Its a multi site system

We have built a search engine for our customer catalog, here is the details:
Post types:
- Catalog (Parent cpt)

Fields:
Motorad number
D1 [mm]
D2 [mm]
H [mm] T°[C]
Seal/gasket
Jiggle Pin
Type
Text – post content
Photo

Taxonomy:
Category of item

- Vehicle (Child CPT of catalog)
Fields:
cc (L)
Year start
Year end
Model – text field

Taxonomy:
- Brand
- Years

- OEM (Child CPT of catalog)
Fields:
OEM Number field
Manufacture

For now the search engine showing the right result but we have 2 speed issues:
1. Because of the relationships once you are trying to search its take too many time to get the result,
We are calling to the Childs CPT (OEM & Vehicle) and showing The Parent CPT (Catalog)
* The search engine appearing at the header all over the site

2. At The catalog Page (for example: hidden link)
We are showing the catalog CPT field and we have TABS Section the showing the childs details (OEM & Vehicle) -
All the single Catalog page are loading too slow

We wiil be more then happy to get some solution for this 2 speed issue's, We considered to develop it again by full custom code because we tried many method to solve it and we didnt found any solution. You are our last chance to solve it without changing from toolset to a custom code.

Thanks

[Shane]

Hi Lina,

Thank you for contacting our support forum.

Normally we would recommend that you have a look at this document below to help optimise your search.
https://toolset.com/documentation/user-guides/front-page-filters/how-to-use-views-parametric-search-on-large-sites/

If this doesn't help please let me know as it is a standard document to cover the basics to ensure the search is running smoothly.

Please let me know as soon as you try the steps there.

Thanks,
Shane

[linaS]

Hi Shane,

Thanks for your reply,

We already tried this method and its still not make any improvement,

Can you check again please and see if there is any other method to improve it?

Thanks

[Shane]

Hi Lina,

Would you mind if I installed a few debugging plugins onto the site ?

This way I can see the loads on the site as it is slow in general.

If you have a test site so I wouldn't have to check on the live site that would be great as well.

Please let me know so that I can proceed.

Thanks,
Shane

[linaS]

Hi Shane,

Yes, You can install and check,

Please let me know if you need anything else,

Thanks

[Shane]

Hi Lina,

It seems like i'm not able to access the site admin page with these credentials you sent, so i'm not able to install any plugins.

Could you update the credentials so that I can gain access to install plugins.

Thanks,
Shane

[linaS]

Hi Shane,

Thanks for your quick reply,

PLease provide me your team IP's, I need to approve it before you will get the option to logged,

Thanks

[linaS]

Iv'e approved your IP you can log in.

[linaS]

Hi Shane,

Because of the page speed we've disable the search engine all over the site,

For now its appearing only at this address: hidden link

Thanks

[Shane]

Hi Lina,

This page is loading quite a lot of information.

So essentially it is quite heavy, the link you sent is also loading up 13 different views.

I'm not seeing in the debug information where caching plugin is installed. I would highly recommend caching since the problem here seems the caused by multiple requests from the database.

https://wordpress.org/plugins/wp-super-cache/

Install this plugin as i'm still not able to access the network admin here hidden link

The page is saying i'm not allowed so i'm limited in what I can do at the moment.

Thanks,
Shane

[linaS]

Hi Shane,

We've installed the caching plugin and it a little bit faster then before but we are still not satisfy from the results.

The main issue cause the following view:
hidden link

this one loaded the vehicle search / results,

Can you suggest how to improve or build it more optimized?

Thanks

[Shane]

Hi Lina,

I looked into this for you .

From what I can see the setup is acceptable because You are filtering the Categories based on the parent view so this i think is fine.

Right now i'm checking the debug in my chrome console to see what script is taking up the load time.

Thanks,
Shane

[Shane]

So i've checked it for you and the issue from what I can see is the images.

Take a look at the screenshot .

This is the waterfall model for the page here hidden link

What I recommend we can try is some image optimisation as well.

https://wordpress.org/plugins/ewww-image-optimizer/

Looking at the script loading it doesn't take much time to load but as you can see the images are taking almost 1s to load.

Thanks,
Shane

[linaS]

Hi Shane,

The problem is not the images loading time,

Its all about the DB queries, each search action look all over the DB to get the result and its take too many time,

there is another optimized way to implement it by toolset?