All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
0answers
20 views

Get all top categories, then only 3 posts for each

I'm building a custom homepage that has that structure:  Cat 1 Post 1 | Post 2 | Post 3 Cat 1 Post 1 | Post 2 | Post 3 etc... I know how to get all top non-empty categories, loop through them ...
0
votes
1answer
36 views

Best way to store 1 billion+ posts?

Hey there I am working on a site that collects a lot of data via scraping. For each data created i'm adding it to WP as a CPT. The problem is I'm going to reach around 1 billion rows eventually, and ...
0
votes
0answers
38 views

Optimize WP site for millions of posts

I have a news portal Using WP cms, It has around 90K posts. DB size 2GB. Used Apache, ngnix, WP Memory Limit 4096M, Time 300 Sec, Using CDN :) I am using 2 Dedicated servers E5 2650 V4, 96GB Ram. ...
0
votes
1answer
43 views

update_post_meta performance in a loop woocommerce

I have a simple question, I am working on the list order screen of woocommerce and want to add some buttons that via ajax will update some data to the database using update_post_meta. The issue is ...
1
vote
0answers
61 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 ...
0
votes
0answers
368 views

WP_Term_Query->get_terms() very slow query for WordPress filter

My first site is almost done, but I am unhappy with how slow the filter-drop downs are populating. My site is for auto-parts so I have many categories with sub categories (Parts -> Type -> Make -> ...
0
votes
1answer
2k views

wp_redirection_404 table has grown to 7GB

The company I work for has an enterprise Wordpress site that was acquired from a different company. I don't know if there was a past hack or if it's just accumulated spam or what, but the ...
0
votes
1answer
30 views

Counting user's comments - efficient way?

As a way to "reward" users, I'd like to showcase their comment count on their comments. However, every answer I've seen as to how to achieve this involves querying the database and counting through ...
0
votes
2answers
468 views

How to combine multiple wp_insert_post into one in order to gain better performance

I need to insert about 300 posts into the DB programmatically. Usually i use wp_insert_post to do this job with one record each time, but this time I don't think it'll work well with hundreds of rows....
1
vote
1answer
84 views

Which is more efficient? Using usermeta, or creating a new MySQL table?

I'm building a bookmarking feature, allowing users to place a marker inside a blog post. The data will then be saved in the database, and retrieved upon opening that blog post. The same concept can ...
0
votes
3answers
1k views

Performance bug - slow DB query

Since 2017-09-26 I have terrible problems with performance on my website. Loading single post or any other page takes even 20s. I've been debugging it it found out, that the problems are DB queries. ...
2
votes
2answers
264 views

Wordpress database becoming huge. How to analyze and optimize it? fear of running out of memory

look at the size of my wordpress database tables: are there simple ways to optimize it? I fear of running out of memory one day maybe bad collation? how can I analyze what is eating up so much space ...
1
vote
1answer
49 views

Optimizing function that automatically creates internal links based on post title string

Problem sovled,thank you @SamuelElh for the tip ,so I relect it in the code.Transient turns out to be the right solution. I wrote a function that adds links to existing post titles that occur in a ...
0
votes
1answer
80 views

Maximum number of posts per page before affecting performance?

How many posts per page, in a normal loop, are too many to start affecting performance on the server? I guess the answer could be "it depends" but I just want to know an approximate number (10? 100? ...
0
votes
1answer
343 views

Mysql Queries per Visit - Crazy High

I have been wrestling with site speed for a while. I have a lot of plugins on a domain-mapped multisite network. One of the bigger offenders is Formidable Pro, which eats up a lot of resources. I ...
0
votes
1answer
224 views

Get posts and include taxonomy term

How can I return taxonomy terms within post data, from the same query. Currently I'm calling get_posts / wp_query and then looping over and calling wp_get_post_terms. Needless to say it thrashes the ...
8
votes
2answers
11k views

Delete all posts of a custom post type—efficiently

I'm looking for a safe and fast way to delete all of one custom post type's posts. Using get_posts() and wp_delete_post() for each returned post does not work; it's not fast enough due to the sheer ...
0
votes
0answers
148 views

Website goes slow down after importing long database

I am working on a site which have 2 lakhs post and 15 categories. I have home page with 3 post of each category on home page. And after that its goes down while run home page and shows page not found. ...
4
votes
2answers
3k views

Slow SQL_CALC_FOUND_ROWS Query

We are experiencing very slow performance with queries that use SQL_CALC_FOUND_ROWS within the admin section of WordPress. We currently have about 125,000 posts on our site and use Varnish to cache ...
0
votes
1answer
1k views

Multiple wp_options tables to share content across installs

My application has >10 user_roles, each able to perform completely different tasks, provided with an custom backend and no access to wp-admin. The extra functionality each user_role gets to use is ...
0
votes
2answers
267 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, ...
1
vote
1answer
262 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
votes
1answer
84 views

Is there a maximum amount of pages for a multi-page post?

I will publish 2 books (encyclopedia) on my site, each with over 4000 pages. My plan is to put each book into a multipage post using the <!--nextpage--> tag. 1. Can Wordpress handle such a ...
3
votes
1answer
1k views

Improve or optimize a very slow query

I have a fairly large database - 113,299 rows in wp_posts and 216,0649 rows in wp_postmeta. There is one custom query that I run after a post is added or edited, which appears in MySQL's slow-log ...
1
vote
1answer
223 views

How to prevent/delay MySQL connections when an object cache is used?

We are using an object cache backed by memcached, however I think that WordPress will still connect to MySQL on every page load, which shouldn't be needed if all queries can be handled by the object ...
4
votes
2answers
873 views

WP_Options ID high

I have a site where the options_id field in the wp_options table has grown very, very large. A month and a half after the installation, the auto_increment value is now at over 10 million. While ...
0
votes
1answer
299 views

Is saving multiple options or saving multiple items in one option better?

I have added multiple fields to a custom taxonomy. I followed Pippin's tutorial. This method creates a single option per taxonomy item. The multiple fields are saved in taxonomy_id. I was not sure ...
1
vote
1answer
154 views

Does auto_load to 'no' in wp_options improve performance

I am trying to improve the performance of a wordpress based blog. I am looking at wp_options table and am thinking to set the column auto_load to 'no'. Does it have any side-effect on the site ...
3
votes
2answers
4k views

WordPress for a very large website

I've searched and searched but I did not find an answer online. Also, I've posted this on StackOverflow and apparently it wasn't ok and I reposted this here. I hope it's ok. I have this website which ...
2
votes
2answers
548 views

Efficiency on displaying random authors based on large database

I'm trying to display a list of 5 authors randomly. Here are some solutions I had found: https://stackoverflow.com/questions/5502609/get-authors-randomly https://wordpress.stackexchange.com/a/91326/...
0
votes
2answers
205 views

Most efficient way of deleting post

I have a cron job set to remove a (sometimes large) number of posts from my database. Of course, I also need to remove all associated data such as custom fields. This is the function I'm currently ...
2
votes
2answers
723 views

Relationship between performance and database size

What's the relationship between performance and database size in WordPress? Does a bigger DB mean that my site will be slower? My DB size is currently 360mb. I also noticed that I have some tables ...
3
votes
3answers
20k views

WooCommerce with thousands of products - site is very slow - optimize db queries? [closed]

So far I've got around 8,000 products in my WooCommerce and the product page on the front end takes several seconds to load, even after caching. My VPS host says that I should have multiple databases....
2
votes
1answer
3k views

WP_Query Performance Issues with meta_query

I'm working on a custom template for a new theme that uses a WP_Query instance to select posts from 2 post types with 2 custom fields that are NOT empty. Depending on the section of the site, a $...
6
votes
2answers
506 views

WordPress database scalability from the code perspective

I have read through multiple questions here on StackExchange that concern WordPress scaling and the common opinion is that WordPress is indeed highly scalable provided you have the infrastructure to ...
5
votes
1answer
579 views

Should I use Transients with W3 Total Cache APC Caching? [closed]

Should I use Transients in my queries like this? <?php if ( ! $my_paged = absint( get_query_var( 'paged' ) ) ) $my_paged = 1; if ( ! $my_query = get_transient( "567recent_$my_paged" ) ) { $...
1
vote
1answer
508 views

One post carries 30 postmeta values, is this too much?

I have some data saved as post meta, occasionally some plugins may save an extra piece. Now I installed bbpress, it saves at least 10 pieces of post meta. Adding them together, there are nearly 35 ...
2
votes
2answers
447 views

Database slowdown after update to 3.4.1

I own a wordpress installation, and Updated to 3.4.1. After the upgrade, I got a very strange slowdown to my wordpress. After all, I used the define('SAVEQUERIES', true); in my wp-config.php with ...
4
votes
3answers
1k views

Performance tips for a large user base [closed]

I’m preparing a site with many users (100.000+). Since the output depends on the current user’s relation to some custom post types and taxonomies a static cache won’t help much. Besides using a ...
14
votes
3answers
756 views

Performance of my permalink structure?

I have read the discussion on the performance of different permalinks on the wp hackers mailinglist, THIS forum and around Google. I could however not really deduce if the permalink structure I have ...