WordPress.org

Support

Support » Plugins and Hacks » [Resolved] [Plugin: Pretty Link Lite] Bad query for high traffic sites

[Resolved] [Plugin: Pretty Link Lite] Bad query for high traffic sites

  • 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/

Viewing 1 replies (of 1 total)
  • Plugin Author cartpauj

    @cartpauj

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

Viewing 1 replies (of 1 total)
  • The topic ‘[Resolved] [Plugin: Pretty Link Lite] Bad query for high traffic sites’ is closed to new replies.