Title: Cache wpdb->result
Last modified: August 22, 2016

---

# Cache wpdb->result

 *  [Slams](https://wordpress.org/support/users/slams/)
 * (@slams)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/cache-wpdb-result/)
 * Dear Ajay,
 * I’m using your plugin and make my own function based on tptn_pop_posts to personalize
   outputs.
 * After inspecting the way you query results I’ve saw that you don’t use [http://codex.wordpress.org/Transients_API](http://codex.wordpress.org/Transients_API)
 * Query monitor plugin always show me information that tptn_pop_posts query always
   slowest.
 * So, I wrapped
    `$results = $wpdb->get_results( $sql );`
 * this way:
 *     ```
       if ( false === ( $results = get_transient( 'tptn_pop_posts_desktop_view' ) ) ) {
               // It wasn't there, so regenerate the data and save the transient
               $results = $wpdb->get_results( $sql );
               set_transient( 'tptn_pop_posts_desktop_view', $results, 12 * HOUR_IN_SECONDS );
           }
       ```
   
 * and got a better performance ! 🙂
 * [https://wordpress.org/plugins/top-10/](https://wordpress.org/plugins/top-10/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Ajay](https://wordpress.org/support/users/ajay/)
 * (@ajay)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/cache-wpdb-result/#post-5820861)
 * Hi Slams,
 * Thanks for the code. It’s definitely something I’ve thought about but kept pending.
   Your code above should cache the mySQL results for 12 hours.
 * Wouldn’t this prevent the sites from showing the latest popular posts?
 * However, being said, that would help those who want to cache the output, so I’ll
   put this into a future release with an option to enable
 *  Thread Starter [Slams](https://wordpress.org/support/users/slams/)
 * (@slams)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/cache-wpdb-result/#post-5820869)
 * Ajay,
 * This code adapted for me, because I display popular posts per month and new data
   don’t needed to me frequently, but you can adopt this api for your purposes.
 * Also, pay attention to this API [http://codex.wordpress.org/Class_Reference/WP_Object_Cache](http://codex.wordpress.org/Class_Reference/WP_Object_Cache)
   
   In some cases it’s better to use Object Cache API.
 * Have a nice day!
 *  Plugin Author [Ajay](https://wordpress.org/support/users/ajay/)
 * (@ajay)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/cache-wpdb-result/#post-5821020)
 * Thanks. I’ll take a look at this.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Cache wpdb->result’ is closed to new replies.

 * ![](https://ps.w.org/top-10/assets/icon-256x256.png?rev=2986432)
 * [WebberZone Top 10 — Popular Posts](https://wordpress.org/plugins/top-10/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/top-10/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/top-10/)
 * [Active Topics](https://wordpress.org/support/plugin/top-10/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/top-10/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/top-10/reviews/)

## Tags

 * [cache](https://wordpress.org/support/topic-tag/cache/)
 * [query](https://wordpress.org/support/topic-tag/query/)
 * [transients](https://wordpress.org/support/topic-tag/transients/)
 * [wpdb](https://wordpress.org/support/topic-tag/wpdb/)

 * 3 replies
 * 2 participants
 * Last reply from: [Ajay](https://wordpress.org/support/users/ajay/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/cache-wpdb-result/#post-5821020)
 * Status: not a support question