[Resolved] View takes forever to load

[Author]

Posts

[suzyo]

Drop-down view takes FOREVER to load. Used to be okay, but it's been 2 months and now it's slow as hell.

hidden link

Here it is. I've got about 20 of these.

When I hit the clear button it takes over a minute to reload.

HALP!

[Minesh]

Hello. Thank you for contacting the Toolset support.

I assume you are using latest Toolset plugins. Can you confirm?
- if yes:

Could you please try to resolve your issue by deactivating all third-party plugins as well as the default theme to check for any possible conflicts with any of the plugins or themes?
- Do you see any improvement or conflict with plugin/theme?

Are you using any cache plugin? What filters you have added to view and how many content you have with those filters?

Could you please send me debug information that will help us to investigate your issue.
=> https://toolset.com/faq/provide-debug-information-faster-support/

What is the problem URL where I can see the issue.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[suzyo]

hidden link

is one of them. there are a bunch more.

[Minesh]

Maybe you forget to answer the following questions asked with my previous reply:

Could you please try to resolve your issue by deactivating all third-party plugins as well as the default theme to check for any possible conflicts with any of the plugins or themes?
- Do you see any improvement or conflict with plugin/theme?

Are you using any cache plugin? What filters you have added to view and how many content you have with those filters?

Can you please try to take those basic debug steps and confirm if you see any different result.

[suzyo]

I deactivated a bunch of plugins BUT that's not it.

Clear on the view works fine EXCEPT for the Vacation Houses ( hidden link )

Trying to fix the view code but I'm I'm impossibly dumb.

[Minesh]

Can you please share how exactly following what steps I can see the issue?

I can see the dropdown is loaded with options for view's filters.

[suzyo]

Minesh, love, I believe I sent you a login and a password.

The link is hidden link

Can you tell me how to fix it? It's showing ALL vacation houses when loaded. I want it to show NOTHING.

Thank you so much.

[Minesh]

Thank you but I try to login using the admin access details you shared but its not working.

Also:
Clear on the view works fine EXCEPT for the Vacation Houses ( hidden link )
===>
I checked the page "rent-a-vacation-house/" and I can see all dropdowns are displayed without any issues with all options. I would like to double check with you - do you have issues in backend edit page or on frontend?

Can you please send me working admin access details.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

It seems you forget to answer the following question:

I checked the page "rent-a-vacation-house/" and I can see all dropdowns are displayed without any issues with all options. I would like to double check with you - do you have issues in backend edit page or on frontend?
===>
Can you please answer and share screenshot or video so that I can see what exactly the issue with dropdowns?

[suzyo]

It's on the front end. When I press the CLEAR button it takes forever to clear and reload.

[Minesh]

Using the admin access details you shared I can login but only access the profile page.

Can you please grant administrator capabilities or role to the user so that I can review how you added the view and if I there is possible way to make any improvements when you click on clear button.

[suzyo]

Oh, I'm sorry. Fixed it, thanks, Minesh.

[Minesh]

Ok - the issue was with your view you were loading all the results from your post type "Vacation Houses".

It is not wise and it will always take time as the query will try to fetch all the posts from the database that will be lead into heavy request to database.

Instead loading all the result - I added the pagination and display 15 results per page to your view.
- hidden link

Added the following pagination shortcode to "Loop Editor" section at end of the loop:

[wpv-pager-nav-links output="bootstrap" first_last_links="true" previous_next_links="true" force_previous_next="true" step="5"]

More info:
- https://toolset.com/documentation/legacy-features/views-plugin/views-pagination/

Can you please confirm now you see much improved result and you're welcome to mark resolve this ticket.

[suzyo]

Thank you SO MUCH, Minesh!

[Minesh]

Glad to know that the solution I shared help you to resolve your issue.

You're welcome to mark resolve this ticket.