> 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.).
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.)
---
Leon Atkinson <http://www.leonatkinson.com/>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
