50,6 → 50,19 |
* - réorganiser les méthodes statiques parmis Observation, ListeObservations2 et ListImages2 |
* - *peut-être*: passer requestFilterParams() en méthode de classe |
* |
* |
* MySQL sux: |
* EXPLAIN SELECT id_image FROM v_del_image vdi WHERE vdi.id_image IN (SELECT ce_image FROM del_image_tag WHERE actif = 1 LIMIT 1); |
* MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery |
* EXPLAIN SELECT * FROM del_image WHERE id_image IN (SELECT 3); |
* PRIMARY |
* EXPLAIN SELECT * FROM del_image WHERE id_image IN (SELECT MIN(3)); |
* DEPENDENT SUBQUERY ... ... ... mwarf ! |
* EXPLAIN SELECT id_image FROM v_del_image vdi WHERE vdi.id_image IN (SELECT ce_image FROM del_image_tag WHERE actif = 1); |
* 5.5: MATERIALIZED del_image_tag ALL ce_image NULL NULL NULL 38276 Using where |
* 5.1: DEPENDENT SUBQUERY del_image_tag index_subquery ce_image ce_image 8 func 1 Using where |
* FORCE INDEX/IGNORE INDEX semble incapable de résoudre le problème de l'optimiseur MySQL |
* |
*/ |
|
require_once(dirname(__FILE__) . '/../observations/ListeObservations2.php'); |