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.
So if anyone is able to help me please do so.
Thank you,
Benjamin Boksa
--
Benjamin Boksa
[EMAIL PROTECTED]
side by site GmbH & Co. KG
Druckgestaltung & Webdesign
Barbarastr. 3-9 (Block 6)
D-50735 Koeln
Telefon: +49 221 2790964
Telefax: +49 221 2790965
http://www.sidebysite.de/
---------------------------------------------------------------------
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