jbaranello

I changed my host as well and it seemed to help slightly as well. I am still working on this but havent resolved it yet.

Sorry I couldnt be more help.

When the data is loaded, the searches are performed quickly. Where I am seeing lagging is when the initial page is loaded it takes a while before the little circle in the browser tab (indicating the data is still loading) to go away.

From what I understand from the developer is that when the page is loaded the query is executed and the data is loaded for you to search.

They were both supposed to return a product so I think something went wrong lol.

Can you please try again and let me know?

Thanks

Hey Piotr,

Thanks for the input but I don’t use WordFence and I am pretty sure it is not .htaccess. How would I go about checking if .htaccess is causing the problem?

Thanks again!!

Thank cure, Ill keep you updated as to whether or not this situation changes.

As a side note it seems that one of my issues still is not fixed. My inventory lookup tool which I created using the wpdatatables plugin still takes forever to load. The initial page load seems OK but the SQL queries that prepare the data for searching seem to take a good 10-20 seconds before they are searchable.

Do you mind confirming this for me? Try searching 13893 in the “Part Number” search box and 12308 in the “Interchange” search box at the following link:

https://voltechrebuilders.com/info/customer-resources/inventory-lookup-tool/

I have already contacted the developer about this issue and they seem to think it is a hosting problem as each of the tables the query is searching is over 5000 rows.

Thanks and let me know what you think!

• This reply was modified 4 years, 7 months ago by jbaranello.

Hey Cure,

I deactivated and re-activated all my plugins and also redid my caching plugin setup. I noticed that not having the “Combine CSS Files” and the “Combine JavaScript Files” seemed to fix my problem for now lol.

I will try again tomorrow and see if the performance is consistent to what I experienced tonight.

Can you please confirm this??

Thanks again for your help!!

I tried what you suggested and I don’t really see a difference. My GTMetrix score was actually better with the Elementor plugin Activated lol.

I think I will try a better hosting plan and see if that helps. I have pretty much exhausted all my other options.

Thanks again!!

Yeah I know, the page load speed is spotty. Sometimes its fast, sometimes it is not, I am assuming all depends on whether it is served from cache or not.

I have tried deactivating the plugins one by one already and didn’t see any speed improvements. I am working with my hosting provider to see what they can do on there end to speed up database queries and such. Apparently my hosting plan does not include Redis or Memcached so object caching is no go for now.

I am using Elementor as a page builder.

Thanks

Well it seems I need the code, I start getting some issues on the back-end in the plugin and theme directory as well as some functions with WP Rocket.

I think what is slowing down the page load is that since there are no actions registered it generates a bad request response.

My page load is definitely faster when I remove that code. Anyone have any ideas on how I can optimize it?

Thanks

Hey Cure,

I removed that code again, please check the link again and let me know if the loading time is still the same.

Thanks

It is a new site (B2B) so won’t have a crazy amount of visitors, just my current customers. I already have over 1500 products in there, which gets updated nightly from our in house inventory program. I am pretty sure the database does have some bloat, I do try to clean it up as often as I can (I use WP Rocket for Caching as well as database cleanup). I recently activated OpCache in my cpanel which I thought helped a little. I basically use WP Rocket for browser cache, css minification, etc. Using OpCache for PHP Script Caching. Trying to setup Memcached for Object Caching now hopefully that will help a little as well.

Also when I had posted my last reply saying I removed some code from my ajax-admin.php which helped the issue a little, this is the code I was talking about. For some reason it came back and I am sure that you visited the link after it came back. Can anyone tell me what this code is for and which plugin uses it?? For me it looks like it doesn’t do anything at all.

if ( is_user_logged_in() ) {
	// If no action is registered, return a Bad Request response.
	if ( ! has_action( "wp_ajax_{$action}" ) ) {
		wp_die( '0', 400 );
	}

	/**
	 * Fires authenticated Ajax actions for logged-in users.
	 *
	 * The dynamic portion of the hook name, <code>$action</code>, refers
	 * to the name of the Ajax action callback being fired.
	 *
	 * @since 2.1.0
	 */
	do_action( "wp_ajax_{$action}" );
} else {
	// If no action is registered, return a Bad Request response.
	if ( ! has_action( "wp_ajax_nopriv_{$action}" ) ) {
		wp_die( '0', 400 );
	}

	/**
	 * Fires non-authenticated Ajax actions for logged-out users.
	 *
	 * The dynamic portion of the hook name, <code>$action</code>, refers
	 * to the name of the Ajax action callback being fired.
	 *
	 * @since 2.8.0
	 */
	do_action( "wp_ajax_nopriv_{$action}" );
}

Thanks

Wow ok, thanks for the great info. After reading your post and the other posts you referenced, I tried a few things and once a removed a few things from my admin-ajax.php that I found weren’t really doing anything, everything seemed to speed up.

Please have a look at the link again and let me know what you think. The admin-ajax process still takes around 2-3 seconds according to GTMetrix but it seems now that it doesn’t affect the loading of the page.

Thanks again!!