> Copying to tmp table | SELECT parent_id, COUNT(*) as dirattr_sort FROM > NAMES GROUP BY parent_id ORDER BY dirattr_sort DESC
Ah, I see this too for large queries that need sorting. If you have space on an SSD drive, it's possible to speed this up by using that for SQL temp tables - ie ie I have in my [server] section of the mysql config tmpdir = /var/lib/mysql/tmp (path can be anywhere, but for us, /var/lib/mysql is all on SSD) which makes it a bit faster... ------------------------------------------------------------------------------ _______________________________________________ robinhood-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/robinhood-support
