Flask/database: research alternatives to how rsids are stored and/or methods to speed up query #754
Description
Rsid based queries can currently take > 10 minutes to run depending on the number of variants associated with the rsid. This is because the rsid is currently stored as a comma delimited string in the variant table and correspondingly searched against using the mysql like operator. A possible option is to store rsid field and its relationship to chr:position as a separate 1:N table, which would require a migration and potentially a one time click command to decompose the table.