Hi.
Disk speed and memory is more relevant than CPU speed most times, so
you should include that info in your comparison. And how big is your
table in bytes (not rows).
I would start with comparing the output of
mysqladmin variables
of all installation. Maybe some simply have a bigger key buffer or
something like this.
Next, compare the output of EXPLAIN for all machines. In any case, it
should be the same for the same MySQL versions. If it differs for any
of the test cases, this could cause the speed difference.
Bye,
Benjamin.
On Tue, Mar 20, 2001 at 07:04:09PM +0200, [EMAIL PROTECTED] wrote:
> 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').
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
