How to create an index for this query

This topic contains 9 replies, has 2 voices, and was last updated by  Stiofan O’Connor 7 years, 1 month ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • March 13, 2018 at 11:39 am #421332

    jedwan
    Expired Member
    Post count: 32

    I’m having hard time creating the right index for this query. Can you help?

    SET timestamp=1520934630;
    SELECT city , CONCAT_WS(‘/’, country_slug, region_slug, city_slug) AS location_link FROM wp_geodir_post_locations WHERE 2=2 GROUP BY city ORDER BY city asc LIMIT 0, 50;
    # Time: 180313 6:08:17
    # User@Host: wordpress[wordpress] @ localhost []
    # Thread_id: 361052 Schema: user_a QC_hit: No
    # Query_time: 2.772355 Lock_time: 0.000095 Rows_sent: 1 Rows_examined: 2542032
    # Rows_affected: 0

    March 14, 2018 at 12:35 pm #421430

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    March 14, 2018 at 12:53 pm #421433

    jedwan
    Expired Member
    Post count: 32

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    March 14, 2018 at 1:43 pm #421443

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    March 14, 2018 at 1:49 pm #421445

    jedwan
    Expired Member
    Post count: 32

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    March 14, 2018 at 3:23 pm #421456

    jedwan
    Expired Member
    Post count: 32

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    March 14, 2018 at 8:30 pm #421482

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    March 14, 2018 at 9:04 pm #421487

    jedwan
    Expired Member
    Post count: 32

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    March 15, 2018 at 4:46 am #421529

    jedwan
    Expired Member
    Post count: 32

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    March 15, 2018 at 4:50 pm #421612

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 10 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount