Title: Performance issue
Last modified: February 17, 2023

---

# Performance issue

 *  Resolved [odoremieux](https://wordpress.org/support/users/odoremieux/)
 * (@odoremieux)
 * [3 years, 3 months ago](https://wordpress.org/support/topic/performance-issue-46/)
 * One of my clients couldn’t access the media library anymore, is was timing out
   every time. The display is 250 items per page.
 * In your function display_post_list_column, the query that gets the post_ids, 
   took over 3 seconds per query, so it’s called 250 times, which caused the timeout.
 * I did some testing, in the query instead of doing LIKE ‘_thumbnail_id’, if you
   do = ‘_thumbnail_id’, from over 3 seconds, it takes 0.3s, 10 times faster, with
   this fix, it doesn’t timeout anymore.
 * In this case the LIKE is not necessary, because you know the exact meta_key you
   are looking for.

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

 *  Plugin Author [Kybernetik Services](https://wordpress.org/support/users/kybernetikservices/)
 * (@kybernetikservices)
 * [3 years, 3 months ago](https://wordpress.org/support/topic/performance-issue-46/#post-16479940)
 * Thank you [@odoremieux](https://wordpress.org/support/users/odoremieux/) for 
   your message.
 * First of all I have to write I never tried 250 items per page in the media library.
 * Can you please clarify if you have the list view or the grid view?!
 * Can you please explain how did you add the option to show 250 items per page?
   As far as I know, WordPress shows 20 items per page.
 *  Thread Starter [odoremieux](https://wordpress.org/support/users/odoremieux/)
 * (@odoremieux)
 * [3 years, 3 months ago](https://wordpress.org/support/topic/performance-issue-46/#post-16480354)
 * It’s the list view
 * On the media library if you go at the top (screen options), you can select the
   number of items displayed on the page. You can do that for any post type
 * Side note the media library has over 67000 items, which has an impact of the 
   query.
 * The LIKE compare characters per characters, = just the string
 *  Plugin Author [Kybernetik Services](https://wordpress.org/support/users/kybernetikservices/)
 * (@kybernetikservices)
 * [3 years, 3 months ago](https://wordpress.org/support/topic/performance-issue-46/#post-16492782)
 * Dear [@odoremieux](https://wordpress.org/support/users/odoremieux/).
 * Thank you again for your message and your suggestion for improvement. I double
   checked the problem and added your solution to the codebase.
 * The new version 13.7 has just been uploaded.
 * Please let me know if you have further issues or improvements. I’m always open
   to any new idea or improvement.

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

The topic ‘Performance issue’ is closed to new replies.

 * ![](https://ps.w.org/quick-featured-images/assets/icon-256x256.png?rev=2478502)
 * [Quick Featured Images](https://wordpress.org/plugins/quick-featured-images/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/quick-featured-images/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/quick-featured-images/)
 * [Active Topics](https://wordpress.org/support/plugin/quick-featured-images/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/quick-featured-images/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/quick-featured-images/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Kybernetik Services](https://wordpress.org/support/users/kybernetikservices/)
 * Last activity: [3 years, 3 months ago](https://wordpress.org/support/topic/performance-issue-46/#post-16492782)
 * Status: resolved