Changeset 94725 in spip-zone


Ignore:
Timestamp:
Jan 23, 2016, 3:07:47 PM (4 years ago)
Author:
cedric@…
Message:

Perf issue : forcer les sous-requetes en uncorrelated http://stackoverflow.com/questions/6135376/mysql-select-where-field-in-subquery-extremely-slow-why#6157797

Location:
_plugins_/selections_editoriales/trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • _plugins_/selections_editoriales/trunk/paquet.xml

    r93688 r94725  
    22        prefix="selections_editoriales"
    33        categorie="navigation"
    4         version="1.2.5"
     4        version="1.3.0"
    55        etat="stable"
    66        compatibilite="[3.0.0;3.1.*]"
  • _plugins_/selections_editoriales/trunk/selections_editoriales_fonctions.php

    r87320 r94725  
    1818
    1919        $select = sql_get_select("DISTINCT id_selection","spip_selections_liens as oooo");
    20         $where = "'".$boucle->id_table.".id_selection $not IN ($select)'";
     20        $where = "'".$boucle->id_table.".id_selection $not IN (SELECT * FROM($select) AS subquery)'";
    2121        if ($cond){
    2222                $_quoi = '@$Pile[0]["orphelins"]';
Note: See TracChangeset for help on using the changeset viewer.