SELECT count(*) FROM tmp__pierre2 SRC INNER JOIN ref__at_lm_chapitres
SUB ON SRC.siteniveau1(VARCHAR(10)) =SUB.site(VARCHAR(10)) AND
SRC.chapitreniveau1(VARCHAR(15)) =SUB.idchapitre1(VARCHAR(100));
sql>select count,sum(cnt) from (select count as cnt from tmp__pierre2 group by siteniveau1, chapitreniveau1) as x;
+--------+------------+
| L2 | L3 |
+========+============+
| 121382 | 1061964254 |
+--------+------------+
1 tuple (54.1s)
sql>select count , sum(cnt) from (select count as cnt from ref__at_lm_chapitres group by site, idchapitre1) as x;
+--------+---------+
| L2 | L3 |
+========+=========+
| 124307 | 1331867 |
+--------+---------+
1 tuple (144.736ms)
how to interpret this result ?
Pierre
De: "Stefan Manegold" <Stefan.Manegold@cwi.nl>
À: "Communication channel for MonetDB users" <users-list@monetdb.org>, "Pierre-Adrien Coustillas" <pcoustillas@1g6.biz>
Envoyé: Lundi 1 Décembre 2014 20:28:48
Objet: Re: inner join very slow
Of what type(s) are the join attributes?
How big is the expected join result?
If you don't know,
select count(*), sum(cnt) from (select count(*) as cnt from tmp__pierre2 group by siteniveau1, chapitreniveau1) as x;
select count(*), sum(cnt) from (select count(*) as cnt from ref__at_lm_chapitres group by site, idchapitre1) as x;
might help to give some estimation / idea ...
Best,
Stefan
On December 1, 2014 6:16:11 PM CET, Pierre-Adrien Coustillas <pcoustillas@1g6.biz> wrote:
>Hello,
>
>
>With this query :
>SELECT count(*) FROM tmp__pierre2 SRC INNER JOIN ref__at_lm_chapitres
>SUB ON SRC.siteniveau1=SUB.site AND
>SRC.chapitreniveau1=SUB.idchapitre1;
>
>
>SELECT count(*) FROM tmp__pierre2;
>+------------+
>| L1 |
>+============+
>| 1 061 964 254 |
>
>SELECT count(*) FROM ref__at_lm_chapitres;
>+---------+
>| L1 |
>+=========+
>| 1 331 867 |
>
>
>after several hours of running the query is still not finished and I
>stopped
>
>
>how to find out where the problem?
>
>
>thanks
>
>
>Pierre
>
>
>--
>1G6
>52 route de bischwiller
>67300 Schiltigheim
>Société de Services et de Formations en Logiciels Libres
>http://1g6.biz
>Tél : 06 64 63 70 35
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>users-list mailing list
>users-list@monetdb.org
>https://www.monetdb.org/mailman/listinfo/users-list