I attempted to reply earlier, but as several hours passed and it didn't come through, I am sending again. My apologies if it turns out to be a duplicate.
At 17:40 +0200 on 25/5/2002, Tzahi Fadida wrote: > 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, I am afraid this is the wrong way to go about it. If that data is going to grow, you'll need to allocate more and more space. It's at times like this that you have to do some ugly "query tuning". In this instance, it would mean selecting the records, unordered, into a temporary table. Then selecting them from there, ordered. Then deleting the temporary table. If it's any comfort to you, I had the same sort of problem with Sybase at work, and the expert the company hired had recommended a similar solution. So it's not just a mySQL thing. Then again, if your data are going to stay the same size, you may keep on looking for the optimization information. How? RTFM - on my SuSE 7.3, the manual is in /usr/share/doc/packages/mysql. Note that you don't increase space per user. You change the parameters passed to the daemon. Herouth -- EMAIL: [EMAIL PROTECTED] HOME PAGE: http://herouth.port5.com/ ================================================================= 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]
