WordPress.org

Ready to get started?Download WordPress

Forums

Pretty Link Lite
[resolved] Bad query for high traffic sites (2 posts)

  1. entelarust
    Member
    Posted 2 years ago #

    In the function generateUniqueVisitorId in PrliClick.php there is a query to make sure there are no collisions. But it is doing it in the most inefficient manner possible.

    $query = "SELECT DISTINCT vuid FROM ".$this->table_name;

    This grabs an array of every click in the db (in our case it was around 200k and tanked the mysql server if a bunch of clicks came in at once)

    This could easily be done using the a count() check with vuid = $vuid

    http://wordpress.org/extend/plugins/pretty-link/

  2. cartpauj
    Member
    Plugin Author

    Posted 2 years ago #

    I agree, this needs to be looked at. I'll add it to the todo.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic