Post Query Accelerator
This plugin has been marked as retired. It is recommended that you no longer use it.
Donate
I’ve spent a lot of time writing this code and supporting it. If you derive some benefit from this code, please consider showing your gratitute in a more tangible
way. Thanks!
I have received $0 this month for my coding efforts.
Hi Mark!
Thanks for the research and excellent plugin!
I just tried out using get_lastpostdate() instead of using the txfx_most_recent_post_time option. It seems to be working fine for me. It eliminates the added option and the code keeping it up-to-date. (And the possible delay on future-dated posts.)
Is there possibly an issue you’ve run into that I’m not accounting for, using get_lastpostdate()?
At least on my site get_lastpostdate() is called anyway, so multiple calls won’t hurt as the value is cached in the PHP code. (It does use $now, but doesn’t call the posts_where hook, so there is no recursion problem, but of course the query will not be cached by MySQL.)
Yeah, using that is only a little tradeoff… it’s only one query, and it’s probably fairly fast. And if you’re using it anyway…
[...] Un autre plug-in très utile, (fonctionne sur Wordpress 2.01), à télécharger sur Post query accelerator qui augmente la vitesse de mise à jour de manière impressionnante en gérant le cache serveur. Blogosphere, plugin, template, wordpress [...]
[...] Another useful plug-in, (functions on Wordpress 1.5 and +), download from Post query Accelerator impressively increases update speed by managing the server cache. Blogosphere, plugin, template, wordpress [...]
[...] Opcode cache helps quite a bit. I use APC. I wrote this plugin to make WP’s posts queries change less, so that you can use MySQL’s Qcache, which helps some more. WP-Cache2 is great (but be sure to read this first if you’re using APC), and I’d recommend changing the cache time to 7200 seconds (default is 3600). [...]
[...] Post Query Accelerator: Sets $now to the time of the latest post, instead of the current time, which allows for MySQL caching of such queries. Read more here about optimising WordPress Share and Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages. [...]
[...] Despite getting a significant speed increase from installing APC and also turning on MySQL’s query cache, I still wasn’t satisfied and I wanted more speed. The next optimisation step I found again came from Mark Jacquith in the form of the Post-Query Accelerator, which ensures that WordPress gets the most out of MySQL’s Query Cache. Here’s how it works in Mark’s own words: WordPress’ post queries always ask for posts with post_date_gmt <= ‘$now’ where $now is set to the current time, to prevent posts in the future from showing up. This means that $now changes with each page load. For high volume MySQL sites, the system administrator might turn on MySQL’s qcache, in order to cache some SQL queries. The problem with $now is that it changes each time, so the query is never exactly the same again, and the cache doesn’t help. This plugin is designed to freeze $now to reflect the time of the most recent post or page. This does the job of preventing future posts from showing up, but doesn’t needlessly change $now on every load. This can lead to rather large query speedups on high volume sites or sites with many posts. If things like qcache and my.cnf are Greek to you, please don’t use this plugin. Those who need this plugin will know that they need it, and without a properly configured my.cnf with query caching, it will do nothing. [...]
Nations (UN) is an international governing body, in the range over which the flat display folded shut against the Councils creation, claiming that it was an order of 400, que es un virus de computer000 stamps and rarely sell out.
canzoni lei
of the dragon
sul pc
www dragonball
pc ci
sulla traduzione
tu testo canzone
le canzoni
[...] Post Query Accelerator [...]
[...] khususnya berhubungan dengan query post Wordpress. Sudah ada pluginnya, bisa didownload dari http://txfx.net/code/wordpress/post-query-accelerator/ Instalasi juga sangat mudah karena tinggal upload ke /wp-content/plugins dan klik activate di menu [...]
[...] more thing is needed to make this all come together: Mark Jaquith’s Post Query Accelerator. As Mark points out on his blog, WordPress “always ask[s] for posts with post_date_gmt <= [...]
I have a question. Did you test 2.1.1 or 2.1.2? After upgrade from 2.0.5 to 2.1.1(2.1.2) it does not work. Status future do not change to publish when they time comes
(
PHP:v5.1.6
MySQL:v5.0.34-log
Radek
pictures concerning my question.
http://img177.imageshack.us/img177/2039/wp1zg8.png
http://img135.imageshack.us/img135/7615/wp2tq9.png
Radek
Hmm… sweet!
Hey there! Great plugin. qcache and my.cnf are NOT greek to me, but what are your recommendations for optimal settings? Or at least ballpark figures. I’ve been reading a lot about them, and there seems to be no “golden rule of thumb” (i.e., best settings for different kinds of sites).
A nice checklist would be helpful.. like “if your SQL stats are like this_____ then your Qcache and key_buffer settings should be in this _____ range”, etc…
Peace.
[...] nation! hi sweetheart! I found an interesting plugin that might help with server load. http://txfx.net/code/wordpress/post-query-accelerator/ __________________ 37 PR3 hardlink trades – AR TGP Network | HQ Teen Softcore Trades contact [...]
Lots of spam starting around comment #19.
Vmware is the next best thing. You can take a server load it with Centos Linux a couple of raid 1 drives and you have 3 to 4 virtual servers. Of course add 4 gig of ram and have a tape or disk base back up and you have a full blown system. Once you make the vmare session aka windows system you just copy it. Vmware virtual servers are the perfect solution to fixed fee consulting or no hassle computing
for more info:
beverly hills office virtual
using this co-location for their dedicated servers
Colocation and hosting services provider
or Scott at 888-603-6333 x 89
to reflect the time of the most recent post or page. This does the job of preventing future posts from showing up, but doesn’t needlessly change $now on every load. For those of you who want more information on this…head here. For those of your that find this is greek to you, stay away. So there you have it people. 7 tips and tricks that the average joe can put together without any high flying need for coding this and that. Digg proof your site. Actually, for those of you
Good site!
Good site!
[...] http://txfx.net/code/wordpress/post-query-accelerator/ [...]
[...] suspend my site, they offered suggestions. Upon hearing I had WP-SuperCache running, they found PostQueryAccelerator and suggested I try that, and they would handle the server config changes to make it work. [...]
dsds
What I do care about is which candidate is most likely to be willing and able to take advantage of the current political moment and move the political center of the country clearly to the ideological left. And given what I care about, I think supporting Edwards is a bit of a no-brainer.
xxcx
thanx
[...] khususnya berhubungan dengan query post Wordpress. Sudah ada pluginnya, bisa didownload dari http://txfx.net/code/wordpress/post-query-accelerator/ Instalasi juga sangat mudah karena tinggal upload ke /wp-content/plugins dan klik activate di menu [...]
Thanks to Oprah, Obama camp claims biggest crowd yet
[...] khususnya berhubungan dengan query post Wordpress. Sudah ada pluginnya, bisa didownload dari http://txfx.net/code/wordpress/post-query-accelerator/ Instalasi juga sangat mudah karena tinggal upload ke /wp-content/plugins dan klik activate di menu [...]
[...] khususnya berhubungan dengan query post WordPress. Sudah ada pluginnya, bisa didownload dari http://txfx.net/code/wordpress/post-query-accelerator/ Instalasi juga sangat mudah karena tinggal upload ke /wp-content/plugins dan klik activate di menu [...]
[...] khususnya berhubungan dengan query post Wordpress. Sudah ada pluginnya, bisa didownload dari http://txfx.net/code/wordpress/post-query-accelerator/ Instalasi juga sangat mudah karena tinggal upload ke /wp-content/plugins dan klik activate di menu [...]
[...] khususnya berhubungan dengan query post Wordpress. Sudah ada pluginnya, bisa didownload dari http://txfx.net/code/wordpress/post-query-accelerator/ Instalasi juga sangat mudah karena tinggal upload ke /wp-content/plugins dan klik activate di menu [...]
If you ask my opinion about this topic I really like. Thank you for sharing your friends. Hope to see you another day.