Very slow processed and queued images queries

  • Resolved juslintek

    (@juslintek)


    7 years, 5 months ago

    Any ideas why these queries are so slow?

    
# Time: 2017-09-29T12:12:03.212940Z
# User@Host: asd6as5d1asd[a5s4d54asd15] @ localhost [127.0.0.1]  Id:  1120
# Query_time: 0.031315  Lock_time: 0.000055 Rows_sent: 1  Rows_examined: 37225
SET timestamp=1506687123;
SELECT * FROM sjwd_ewwwio_images WHERE pending = 1 LIMIT 1;

    70000 rows. Any ways to filter out unused images and remove them?

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Very slow processed and queued images queries’ is closed to new replies.