Paste EXPLAIN SELECT ... (your SELECT); from the mysql client.
> Hi!
>
> When I join 4 tables with about 3000 records in each mysql seems to work
> forever on "copying to tmp table".
>
> I wonder what that could be. I have enough free space in the tmp-dir and
> don't know what else could it be.
>
> The database-model is normalized and on another machine it takes
> me about 1
> second to get a response.
>
> The strange thing about it is, that it worked before.
---------------------------------------------------------------------
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