Questions tagged [optimization]

The tag has no usage guidance.

56 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
323 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
0answers
10 views

How to show optimized list of posts with all their attachment images

In page-images.php template I have created this code which displays a list of posts which belong to a category and order them by meta value. So basically it is like a category page, generally nothing ...
1
vote
0answers
103 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
82 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
159 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
744 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
243 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
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
0answers
157 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
145 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 ...
1
vote
1answer
265 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 ...
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 ...
0
votes
0answers
13 views

Why does my site download two different versions of the same image?

On both my homepage I have a masonry layout with thumbnails. These are lazy-loaded by JetPack. I noticed that for every thumbnail, two images are being loaded. One with a request url of https://i2.wp....
0
votes
1answer
20 views

Is there a better way to resize and compress/optimize images without using a plugin?

Images resized through Wordpress' add_image_size function seem to be notoriously blurry and too heavy (file-size-wise): When I compare the outcome of manual resizing of a JPG image with OS X's Preview ...
0
votes
0answers
7 views

Is it possible that WordPress keeps old plugins languages in wp-content/languages/plugins?

I just discovered that an updated WordPress install in which I deactivated plugins a long time ago has kept the old languages files in the folder wp-content/languages/plugins. According to the Query ...
0
votes
0answers
17 views

How do you A/B split test a blogs landing page?

I have a shop and a blog. Currently they are split between two URLs, for example johnsmith.com and johnsmithshop.com Most people know me by johnsmith.com, and go to that URL even when they plan to ...
0
votes
0answers
36 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
27 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
53 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
17 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
85 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
1answer
128 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
0answers
33 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
52 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
2answers
594 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
0answers
40 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
57 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
310 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
75 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
2answers
46 views

Is it inefficient to repeat a Shortcode 100 times on a page?

I've been using shortcodes for cutting down on the amount of html I have in my visual editor. I have a shortcode [person] with features name, age, location, phone, and description. I want to list my ...
0
votes
0answers
54 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
1answer
773 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
575 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
0answers
29 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
1k 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
2answers
273 views

Optimising amount of calls to custom fields

I have this code fragment in my codebase: foreach($this->adverisers as $adveriser) { $this->data[$adveriser->name]['image'] = bfi_thumb(get_post_meta($adveriser->ID, ...
0
votes
1answer
56 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
300 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
107 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
0answers
87 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. ...