On Tue, 27 Feb 2001 14:48:40 -0800, Leon Atkinson wrote:

>Whenever you do an ORDER-BY clause in MySQL, it creates a temporary table to
>do the sorting on.  By default temporary tables are done in memory, and the
>available memory is relatively limited.  It's possible that between versions
>of MySQL that memory size was changed, but in any event you'd run into this
>problem eventually, I think.  One way to combat it is to tweak the settings
>for MySQL, which are in a file called my.cfg.  (It doesn't have to exist,
>and I think it isn't there by default.  You'll have to check the docs.).
>

Yesss,
it was a memory problem! I fix the My.cfg value and now all it's ok.

Many thanks to all the people that try to help me.




--
Stefano Orsi 
Email: [EMAIL PROTECTED]
OGCs. - corporate hypermedia
http://www.ogcs.com





------------------------------------------------------------
To subscribe:    [EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Site:            http://www.working-dogs.com/freetrade/
Problems?:       [EMAIL PROTECTED]

Reply via email to