Changeset 99738 in spip-zone


Ignore:
Timestamp:
Sep 29, 2016, 9:42:38 PM (3 years ago)
Author:
tcharlss@…
Message:

v3.4.0 : report rétro inversé en arrière de r94724 (qui concernait la branche 2).
On incrémente également le Y.
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_/albums/trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • _plugins_/albums/trunk/albums_fonctions.php

    r99514 r99738  
    3131
    3232        $select = sql_get_select("DISTINCT id_album","spip_albums_liens as oooo");
    33         $where = "'" .$boucle->id_table.".id_album $not IN ($select)'";
     33        $where = "'" .$boucle->id_table.".id_album $not IN (SELECT * FROM($select) AS subquery)'";
    3434        if ($cond){
    3535                $_quoi = '@$Pile[0]["orphelins"]';
  • _plugins_/albums/trunk/paquet.xml

    r99737 r99738  
    22        prefix="albums"
    33        categorie="multimedia"
    4         version="3.3.28"
     4        version="3.4.0"
    55        schema="1.0.0"
    66        etat="stable"
Note: See TracChangeset for help on using the changeset viewer.