search

hquxmu / ai-contest

Automatically exported from code.google.com/p/ai-contest
0 stars 0 forks source link

Compiler daemon optimization #140

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
While the compilation was not working properly, I did, as recommended try to 
re-submit my solution after a while. Multiple times. Now, when it finally 
started to work, ALL of my submissions were compiled, instead of the last one 
only.

So, I wrote a patch that modifies the SQL query in the 
submissions_to_be_compiled function of compile_daemon. By the way, it should 
improve the performance a little, as it now uses the auto-incrementing index 
for sorting, not the timestamp.

Original issue reported on code.google.com by gvsmirno...@gmail.com on 13 Sep 2010 at 1:56

Attachments:

GoogleCodeExporter commented 8 years ago 
Just glancing at it, I don't understand what the MAX() calls are supposed to 
accomplish in this case.

Original comment by dar...@technofovea.com on 20 Sep 2010 at 4:57

GoogleCodeExporter commented 8 years ago 
Since a GROUP BY clause is added, all that is selected must be aggregated. 
MAX(email) returns just the email, and MAX(s.submission_id) returns the latest 
submission ID.

Original comment by gvsmirno...@gmail.com on 20 Sep 2010 at 7:06

GoogleCodeExporter commented 8 years ago

Original comment by janzert on 6 Nov 2010 at 3:49