arq5x/gemini — pull request #123 by roryk (2013-05-01 01:44:22+00:00)
Title: Slightly faster annotations

This could use more speedups; it takes 10-15 hours or so to add a small file to a 1k genomes database. This at least makes it usable on larger databases.

I think it might be faster to load the BED file as a temporary table and join on it. My SQL kung fu is weak so I'll need a little more time to see if I can get something like that working for each of the annotation cases.