tree 8fe8dcf270d45fb413615a9606740238e067c8d6
parent 79ab8e645931803eb5ed844683f9923ab3555ec9
author marination <maricadsouza221197@gmail.com> 1643976296 +0530
committer marination <maricadsouza221197@gmail.com> 1643976500 +0530

perf: Weed out disabled variants via sql query instead of pythonic looping separately

- If the number of variants are large (almost 2lakhs), the query to get variants and attribute data takes time
- If the no.of disabled attributes is large as well, the list comprehension weeding out disabled variants takes forever
- We dont need to loop over the variants data so many times
- Avoid any `if a in list(b)` is best when the iterables have tremendous data