ApolloFortyNine / SongSense

Program that will find users with the most similar top beatmaps to you.
GNU General Public License v3.0
1 stars 0 forks source link

Make 1 query instead of 50 #59

Closed ApolloFortyNine closed 8 years ago

ApolloFortyNine commented 9 years ago

SELECT DISTINCT beatmap_id FROM beatmaps b WHERE b.beatmap_id NOT IN (SELECT beatmap_id FROM beatmap_info)

There may be a way, similar to the above, to write one query that does the work of all 50.

ApolloFortyNine commented 9 years ago

Or maybe use many and statements, like ((beatmap_id == x[0].beatmap_id & enabled_mods == x[0].enabled_mods) & (beatmap_id == x[1].beatmap_id & enabled_mods == x[1].enabled_mods))

Though it may return too many at one time, using too much memory. yield_per might be useful here.

ApolloFortyNine commented 8 years ago

Same as #81