Hello, I'm trying to run below query, but the query is timing out and takes 7+gb of temp table storage calculation then times out. Does anybody see what might be a problem with this query and why it doesn't perform in memory?
SELECT owner as __group__, DATE(FROM_UNIXTIME(time)) as Created,version, milestone, count(*) AS 'Count of Tickets' FROM ticket WHERE time > UNIX_TIMESTAMP(NOW() - INTERVAL 1 MONTH) and status = 'closed' GROUP BY owner,DATE(FROM_UNIXTIME(time)),(milestone IS NULL), milestone ORDER BY owner,DATE(FROM_UNIXTIME(time)) DESC ,(milestone IS NULL), milestone Thanks Lucas -- http://lucasmanual.com/ <http://lucasmanual.com/blog/> -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
