Quoting Tzahi Fadida <[EMAIL PROTECTED]>: > thought about it, but i can't control any of this from the lycos web > interface to mysql. > If you know how to do it, please add more details on how to add this > temporary space to > a user on mysql.
Well, in my judgement, the solution is not increasing space for mysql, however it is done. As soon as your tables grow larger, and the set of returned data is doubled in size, you'll have to double the space, and so on. It is at this point that we move from "database theory" to practical database management. That is, you don't use the statement as you described it, but you select into a temporary table, without the order by clause, and then you select from that table with order by. Delete the table after this is done. Ugly? That's query tuning for you. If it's any comfort to you, I had similar troubles with Sybase at work, and the expert the company hired recommended exactly the same sort of solution. So it's not just mySQL which sometimes runs into the wall. Herouth ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
