Database queries way too big?

  • Resolved raphaelw

    (@raphaelw)


    1 year, 7 months ago

    Hi guys,

    i use the UR plugin since a while now and it perfectly fit my needs, so thank you for the work and share!

    However, since my website has a big amount of user (currently around 150.000), i noticed that there were some huge mySQL queries from the front-end homepage.

    The query is the following:
    SELECT user_id, meta_key, meta_value FROM usermeta WHERE user_id IN (….)

    There are thousands of user ids into the brackets.

    So those queries are slowing down the database server.
    And isn’t it a security issue about querying all users data in one shot from the front-end?

    Any help would be much appreciate if you have an idea of solution.

    Kind regards,

    Raphael

    • This topic was modified 1 year, 7 months ago by raphaelw.

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

Viewing 6 replies - 1 through 6 (of 6 total)
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Database queries way too big?’ is closed to new replies.