Hello,
I encountered following problem: when using older mysql (3.22.23 vs
3.23.33) then older is about 4-6 times faster on the same machine. What
could be the problem? Sytem is Debian 2.2r2, older mysql was from .deb but
newer i built myself. The query looks like this:
SELECT f.foto_id, f.imgname, f.path FROM foto f, indeks k1, indeks k2
WHERE f.foto_id = k1.foto_id AND k1.word = 'mati' AND f.foto_id =
k2.foto_id AND k2.word = 'kose' GROUP BY f.foto_id;
Where foto has ~8000 rows and indeks has ~150000 rows (words) and result
has 1266 rows.
Here are some testing results on different machines and op. systems:
3.22.32 - 3 sec (Debian, PIII 600)
3.22.32 - 6 sec (Debian, Cel 333A)
3.23.32 - 24 sec (RH7, Dual PIII 500)
3.23.33 - 36 sec (Debian, Cel 333A)
3.23.29a-gamma - 71 sec (FreeBSD, PIII 550) ????
3.23.29a-gamma - 90 sec (FreeBSD, Cel 333A) ????
And what is most amazing... It's SOO slow on BSD. I wonder why?
Or are there any ways to make this query faster? Sometimes there will be
even 3 or more words (here only 'mati' and 'kose').
Rgds,
Viljo
