Simple postmeta inner join query is taking 2sec to execute
“<p>Wordpress site with around 150000 posts. I have a query that gets executed mulitiple times per page load and it is unreasonably slow - on the order of 2sec:</p>
<pre><code>SELECT COUNT(*) as cnt
FROM wp_postmeta pm, wp_posts p
inner join wp_posts p2 on p2.ID = p.post_parent and p2.post_status in”
stackexchange · jeromio · 2/14/2025
Open original →Ask HN: Is It Time for a WordPress Alternative?
“I can totally relate to your frustration. I recently tried using WordPress to set up a company website for me, and it was honestly a pretty awful experience. Between the constant need for plugins, slow loading times, and dealing with themes that didn’t quite work out of the box, I felt like I was sp”
hackernews · ms7892 · 10/18/2024
Open original →Delayed server responses when logged in to wordpress admin on one browser (any browser!) for a while
“<p>This issue sounds kind of ridiculous, but I’ve pinned it down as best I can and ruled out anything obvious.</p>
<p>When I’ve been logged in as admin and working on my site in a browser for a while (“a while” is variable, but maybe half an hour to a few hours), it starts to get extremely slow to l”
stackexchange · Avery · 8/14/2024
Open original →Slow Performance of WordPress Site on Docker with Azure MySQL and GitHub Files
“<p>I'm using Docker to contain a WordPress site (on localhost) for a team demo project. Our setup includes:</p>
<ul>
<li>MySQL database hosted on Azure.</li>
<li>WordPress files stored on GitHub, copied into the container's WordPress folder during the build process.</li>
</ul>
<p>Issue: The site is ”
stackexchange · Thomas Ravetto · 8/7/2024
Open original →MySQL Database Performance Decimated After Server Migration
“<p>I have a CRM that I've built over the past couple of years that has been working fine. The database is MySQL, and the front end is a web interface. This week, we 'upgraded' our hosting plan from a shared server to a cloud server, and immediately we saw a complete collapse of performance on some”
stackexchange · Mike Johnson · 4/27/2024
Open original →