Looking for some SQL advice with my line-up optimizer.
With up to 15 games / 30 players per position, there are 1,237,940,039,285,380,000,000,000,000 (8^30) possible line-up permutations (my pitcher spot is done seperately). This number gets squashed when I use a baseline for total points (greater than) and total dollar value (less than or equal to).
The problem I’m having is I can only run the query on the top 10-12 or so players from each position… after that the SQL engine breaks.
Any tips?