At 22:48 27/02/01, you wrote:
> > In the example above in effect i remove the order method but i never
>tested on
> > FreeTrade module.
> >
> > It's very strange that in 6 month (or more) i never had this problem and
>now i have
> > this problem on all 3 sites ...bah!
>
>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.).
its called .my.cnf and should be installed in the user's home dir
examples of it (on my installation) are in /usr/local/share/mysql
>Another way to deal with it is to force the temporary table to disk. This
>can be done on a per-query basis with a special mysql command. It's
>something like SQL_BIG_TABLES=1 or something. (Aren't we using this in
>FreeTrade already? It seems like we added that.)
freetrade/modules # grep -r 'SQL_BIG_TABLES' *
came up with nothing
>---
>Leon Atkinson <http://www.leonatkinson.com/>
>
>
>
>
>------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Site: http://www.working-dogs.com/freetrade/
>Problems?: [EMAIL PROTECTED]
bye
Bob Hutchinson
[EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
