r-anime/awards-web

Rework character/VA searching

Closed this issue · 0 comments

Building our own database of shows/characters is the right idea and it works quite well for shows since there are at most 400 entries resulting in smaller responses from AL. However, as of now, there are roughly 4000+ characters from shows that aired in 2020. This is a little less than 90 queries, with MBs of data needing to be downloaded before voting can proceed. Even more ridiculous is how the front-end then has to search through those 4000 entries every time a search query is performed.

The only way I can see this working is an optional column in the entries table that records character names/show names. This column will be searched on the back-end to provide a filtered list of matches. The data for those matches will then be fetched from AL. Not the cleanest of solutions but it'll have to do.