Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [optimization]

The tag has no usage guidance.

3
votes
1answer
213 views

Speeding Up Bulk Post Creation - wp_insert_post & update_post_meta

I am creating posts (variable products) using (wp_insert_post) function. An Example, I have 9 colors, 9 sizes. Which makes 9×9 = 81 total variations for 1 product, which is 81 times below function to ...
1
vote
1answer
1k views

Cleanup: best way to remove WooCommerce comments from the wp_comments table

I am optimizing the database of my site that is using WooCommerce. When I came across the wp_comments table, I found it close to 100 MB in total. It's all filled with WooCommerce order statuses from ...
1
vote
1answer
2k views

How to solve 'Eliminate render-blocking JavaScript and CSS in above-the-fold' content for multiple files?

I get this when I check my site in google insight: Pretty ok right? But I still consider to fix Eliminate render-blocking JavaScript and CSS in above-the-fold content to get a good results on mobiles ...
1
vote
1answer
261 views

fastest replacement DB

What's the best database setup for WordPress for speed and lots of posts (hundred thousands of rows in posts and post_meta tables)? While I can cache as much as I can and optimize my queries/PHP as ...
0
votes
1answer
90 views

Need to optimize wordpress websites on google pageinsight

I am trying to optimize my websites on pagespeed insight. And, for this I have tried lots of speed optimization wordpress's plugins and all have very good ratings by the users. But not even single ...
0
votes
1answer
321 views

How to optimize wp_option table?

My Wordpress website is often going down with the error message "error establishing a database connection" and when I contacted my hosting server, they replied that the query takes a long time(more ...
0
votes
1answer
702 views

Database Queries Optimization with new WP_Query

I’m building (mostly with a self-teaching purpose) a simple plugin to query posts from another blog on a MS network via a shortcode (like [network-posts blogs=”8" layout=”grid” columns=”3"]), but I’m ...
0
votes
1answer
522 views

batch UPDATE autoload value in wp_options table

After running the following query SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'; I've found I got 1587 autoloading options values, mostly belonging to custom fields values; ...
0
votes
1answer
191 views

Varnish + Nginx for Wordpress is Good?

i m instaling my new server and trying make some good environment for my wordpress so i wanna know if installing Varnish + Nginx is good idea and will speed up my wordpress website or there is other ...
0
votes
1answer
54 views

ordering and optimizing functions

Ive been hard at work trying to build some functions to display products on my site. The prices for these products are calculated based on many variables. I think the first set of functions work, ...
0
votes
1answer
279 views

Combine several CSS files into one

I've been working on a site where specific CSS files have been written and loaded only when required. I would like to combine all those scripts into one single file. I'm not interested in minifying ...
0
votes
1answer
106 views

Recent posts headlines. How to optimize the loop

I'm using this in my page template to display the 20 recent posts headlines from category number 8, 17, 23, 423 <div id="horizontalTab"> <ul class="resp-tabs-list"> <li>...
0
votes
1answer
190 views

Optimizing multiple WP_querys into one call?

I have finished building my website and noticed due to the structure it takes 3 seconds to load the data due to each WP_query bouncing between different post types. I was wondering if I put these into ...
0
votes
1answer
82 views

What can cause JavaScript and CSS files to be minified?

On one of my client's site, I see that my plugin's JS and CSS files are minified. Trying to identify what causes the files to minify, I tried to deactivate all plugins (except mine), and changing the ...
0
votes
1answer
48 views

Cache metadata for set of posts

I have a query that can only be done using straight SQL, but I need to loop through the returns as a set of posts. As I understand it, WP_Query automatically gets all the metadata for all the posts ...
-1
votes
1answer
55 views

How to make wordpress backend mobile optimized.?

I have a membership website where my users can create their own page. Most of my users are from mobiles (they do not have laptops). When I open my website in android chrome browser, the WordPress ...
1
vote
0answers
65 views

What type of index should I use for postmeta?

I already added a composite index but it still took 5 seconds to finish these 2 queries. SELECT COUNT( DISTINCT( wpp.id ) ) FROM `wpdgls_posts` wpp JOIN `wpdgls_postmeta` wpm ON wpp.id = wpm.post_id ...
1
vote
0answers
43 views

how to solve slow WordPress site caused by attachment_metadata

My WordPress sites starting to become slower by time, after two years they become very slow. I tried many things, such as: improved my DB, used cache plugins (WP Rocket and W3 Total Cache) which both ...
1
vote
0answers
128 views

Query posts without meta preload

I'm optimizing high traffic website. Trying to solve following issue: Site's home page is extremely slow and top showing 100% CPU because of Mysql. After some investigation with Query Monitor plugin, ...
1
vote
0answers
660 views

admin-ajax.php + load-scripts.php hanging for minutes

My issue is that when I do a simple Admin Dashboard change, like updating a post or page, I sometimes wait up to 10 minutes for the request to finish. I have tried restarting the process and my ...
1
vote
0answers
39 views

SuperCache for Custom Templates

I've started creating custom templates. For instance, I wanted a news template for posts that are news oriented. So, I made news.php <?php /* * Template Name: News Article * Template Post Type: ...
1
vote
0answers
188 views

Cron Job Keep Running in spite of being disabled

I have Cron job issue in two of my sites (both hosted in siteground). It almost runs for every request made to the site I have added following code to wp-config.php file define('DISABLE_WP_CRON', ...
1
vote
0answers
153 views

Least expensive way to get table prefix in multisite installation

I am writing an api that will have to handle extremely high volumes of calls so, in short, I can not afford to load the WordPress core every call. I have no problem building the API to use the ...
1
vote
0answers
137 views

Wordpress backend delay by server side HTTP Request

I had 50 seconds of loading time for my backend in wordpress. I thought it was very strange for a DB to be so slow and I realized with the help of the Query Monitor plugin that the server is making ...
1
vote
0answers
88 views

What would Repair and Optimize Wordpress Database do?

Recently I am getting an error establishing a database connection in a clients Wordpress site. I googled for a solution and an article suggested to enable Wordpress Repairs by adding this to the wp-...
1
vote
0answers
34 views

Any suggestions on how to make this function more efficient or more generally useful?

I wrote this to handle sanitizing all the fields in $_POST before saving them to options and to sanitize and initialize everything before creating the form. You can use the same $soap array to handle ...
1
vote
0answers
68 views

Wordpress problematic caching

I am looking at ways to optimize the speed of a Wordpress website and found that there is a css file containing a ridiculous amount of useless css and was contributing to the site's very slow loading ...
0
votes
0answers
10 views

How to stop my popups from loading before opening them?

My popups each has a gallery full of pictures, which is all downloaded the time you enter the website. Which makes my website very heavy. i use the "popup builder" plugin, which doesn't has that ...
0
votes
0answers
22 views

Webpack 4: combine core and plugins in unique build/admin.js?

I'm going through @wordpress/scripts but it's not clear to me how to emit a unique 'build/output.js' which would combine / merge all the assets (admin and plugins) through webpack 4. Let me explain. ...
0
votes
0answers
19 views

Reusing old post IDs

When I exported my posts I noticed that some of the ID numbers were missing e.g. it started from 8 and went to say 21 and then from 24 to 30 etc. Is it possible to reuse IDs 1-7 (or any others that ...
0
votes
0answers
35 views

Wordpress Query optimaization for slow query

I've WP installation with some 120K posts. One of the slow queries that frequently appear at @mysql-slow.log is below # Query_time: 1.744827 Lock_time: 0.000567 Rows_sent: 1 Rows_examined: 635732 ...
0
votes
0answers
15 views

Uncached* Page Speed

I have a woocommerce based website. I'm using WP-ROCKET for caching and i happy with it for cached website pageload is 1second but uncached webpages like search or a new page this pageloads takes ...
0
votes
0answers
6 views

Printing extra scripts before src scripts to optimize minification and page speed

In WordPress a plugin may add extra data to be printed before or after a script when enqueueing a script. Quite a few plugins that we have enabled do this to define for example an ajax URL etc and it ...
0
votes
0answers
16 views

How to optimize backend? Remove unneeded queries on All posts page primary

How to disable tags, categories, authors and date in All posts page? Any post type. In Screen options I have removed everything (author, categories, tags, comments, date) but in reality this doesn't ...
0
votes
0answers
16 views

Does &$this is really disallowed to use anywhere?

I got this message from the validator of plugins from Envato: When creating a callable, never use &$this, use $this instead: I think he may be wrong with his 'never use'. Are we ...
0
votes
0answers
39 views

How to prevent Vimeo duplicate requests?

I've been tasked to optimize a wordpress site (big surprise...) and found that Vimeo embeds duplicates of their player api js file. I would have thought the browser would prevent this but apparently ...
0
votes
0answers
31 views

Is there any way to get all custom posts and all custom terms with it's meta in few queries?

I'm developing a website with a record for me query count. It has 720 Query for the main page. I want to reduce it. The main page structure is like this: ~10 Custom Taxonomy Term Each Term has a ...
0
votes
0answers
38 views

Can lots of tags affect performance?

I'm working on a plugin that will auto-tag my posts (it's for a very specific, single project only). It will apply 6 tags based on the content of the post. Forward thinking, I wonder if the number of ...
0
votes
0answers
39 views

Why are the latest visits to my website originating from my own website?

To start with, I don't know anything about coding and stuff. I am here to seek help from experts hoping they can help me resolve the issue. I have a website/blog that runs on WordPress. I have a VPS ...
0
votes
0answers
18 views

How can I stop widgets from re-executing every time I access the logged-in homepage?

I have a few widgets and they're being built-up every time someone accesses their logged-in homepage. I assume this is so that everything works nicely. Unfortunately, this is a tremendous ...
0
votes
0answers
52 views

Above the fold plugin error “The Proxy Cache directory contains n cache entries.”

I've just starting using this plugin with a site that I did not code or configure. I'm getting this error: "The Proxy Cache directory contains n cache entries. This may indicate that auto-capture ...
0
votes
0answers
193 views

Serve resources from a consistent URL GT Metrix

I am optimizing WordPress website speed and i have fixed all other issues mentioned by GT metrix (Website to test website speed) but could not fix Serve resources from a consistent URL. I know there ...
0
votes
0answers
40 views

Number of queries in wordpress

I have 870 queries in 3,216 seconds. Is that normal? What are that queries? How can I reduce that queries? What is number of normal queries. Custom Page: 870 queries in 3,216 seconds. Home Page: 866 ...
0
votes
0answers
62 views

How to optimise this database query?

I need to collect several tables for posts, and this is currently my query: $result = $wpdb->get_results( " SELECT p.ID AS id, pm.meta_value AS text, pm2.meta_value AS ...
0
votes
0answers
53 views

Run command to optimize images after they get uploaded to WordPress

I been playing with jpegoptim on a ubuntu test server and like the result of its optimization, its there a way to run the optimization command to the new images uploaded through WordPress? Im aware ...
0
votes
0answers
28 views

Is there a way to analyze the load time of the functions in a custom plugin?

I have a custom plugin that is adding on average 1 second to the page load time. I thought the code was well written, but clearly not. Is there any way for me to find out what aspect of the plugin in ...
0
votes
0answers
995 views

Optimize WP_Query

For the homepage WP_Query loop, I need to get the most recent 20 articles, specifically to display the page title, excerpt, category, and date. I am doing the following: $args = array( '...
0
votes
0answers
86 views

Most efficient way to list all categories and display a post for each of them?

I'm working on a blog that has around 8.000 posts and 50 categories. The task I'm working on is to list all categories and for each category to show the latest post with a certain custom field value. ...
0
votes
0answers
468 views

Plugins enqueuing jquery in head

I am trying to optimise my site for mobile and enqueued my scripts to be placed in the footer so as to eliminate render-blocking javascript in above the fold content. Unfortunately some of the plugins ...
0
votes
0answers
43 views

admin.php taking 14 seconds

This is a clean install but it has a (relatively) huge database of dummy posts/comments/etc. But even on single-post loads it still takes just as much. Narrowing further down menu.php takes 8 seconds ...