Changeset 94723 in spip-zone


Ignore:
Timestamp:
Jan 23, 2016, 3:01:05 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_/mesfavoris/trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • _plugins_/mesfavoris/trunk/mesfavoris_fonctions.php

    r91248 r94723  
    5757        $in = "sql_in('$primary', prepare_mesfavoris($objet,$type), '')";
    5858        $type1 = "mesfavoris_definir_type($type)";
    59         return "$type1 ? array($type1,'$id_table.$primary','('.sql_get_select('zzza.$primary','$table_objet as zzza',$in,'','','','',\$connect).')'):''";
     59        return "$type1 ? array($type1,'$id_table.$primary','(SELECT * FROM('.sql_get_select('zzza.$primary','$table_objet as zzza',$in,'','','','',\$connect).') AS subquery)'):''";
    6060}
    6161
  • _plugins_/mesfavoris/trunk/paquet.xml

    r93417 r94723  
    22        prefix="mesfavoris"
    33        categorie="navigation"
    4         version="2.4.3"
     4        version="2.5.0"
    55        etat="test"
    66        compatibilite="[2.0.0;3.1.*]"
  • _plugins_/mesfavoris/trunk/plugin.xml

    r93417 r94723  
    33        <slogan>S&#233;lection de favoris</slogan>
    44        <icon>images/mesfavoris-128.png</icon>
    5         <version>2.4.3</version>
     5        <version>2.5.0</version>
    66        <version_base>1.2.0</version_base>
    77        <etat>test</etat>
Note: See TracChangeset for help on using the changeset viewer.