Line 48... |
Line 48... |
48 |
* - éviter de dépendre d'une jointure systématique sur `cel_obs`, uniquement pour `(date_)transmission
|
48 |
* - éviter de dépendre d'une jointure systématique sur `cel_obs`, uniquement pour `(date_)transmission
|
49 |
* (cf VIEW del_image)
|
49 |
* (cf VIEW del_image)
|
50 |
* - réorganiser les méthodes statiques parmis Observation, ListeObservations2 et ListImages2
|
50 |
* - réorganiser les méthodes statiques parmis Observation, ListeObservations2 et ListImages2
|
51 |
* - *peut-être*: passer requestFilterParams() en méthode de classe
|
51 |
* - *peut-être*: passer requestFilterParams() en méthode de classe
|
52 |
*
|
52 |
*
|
- |
|
53 |
*
|
- |
|
54 |
* MySQL sux:
|
- |
|
55 |
* 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);
|
- |
|
56 |
* MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery
|
- |
|
57 |
* EXPLAIN SELECT * FROM del_image WHERE id_image IN (SELECT 3);
|
- |
|
58 |
* PRIMARY
|
- |
|
59 |
* EXPLAIN SELECT * FROM del_image WHERE id_image IN (SELECT MIN(3));
|
- |
|
60 |
* DEPENDENT SUBQUERY ... ... ... mwarf !
|
- |
|
61 |
* EXPLAIN SELECT id_image FROM v_del_image vdi WHERE vdi.id_image IN (SELECT ce_image FROM del_image_tag WHERE actif = 1);
|
- |
|
62 |
* 5.5: MATERIALIZED del_image_tag ALL ce_image NULL NULL NULL 38276 Using where
|
- |
|
63 |
* 5.1: DEPENDENT SUBQUERY del_image_tag index_subquery ce_image ce_image 8 func 1 Using where
|
- |
|
64 |
* FORCE INDEX/IGNORE INDEX semble incapable de résoudre le problème de l'optimiseur MySQL
|
- |
|
65 |
*
|
53 |
*/
|
66 |
*/
|
Line 54... |
Line 67... |
54 |
|
67 |
|
55 |
require_once(dirname(__FILE__) . '/../observations/ListeObservations2.php');
|
68 |
require_once(dirname(__FILE__) . '/../observations/ListeObservations2.php');
|
56 |
require_once(dirname(__FILE__) . '/../observations/Observation.php');
|
69 |
require_once(dirname(__FILE__) . '/../observations/Observation.php');
|