Closed RasmusKard closed 2 months ago
What?
Don't join genres and titleTypes ID columns with the strings of the lookup tables. Rather do the conversion from ID to string in JS.
Why? Conversion is necessary for only the one row that is returned from randomized selection. The join unnecessarily complicates the SQL query.
What?
Don't join genres and titleTypes ID columns with the strings of the lookup tables. Rather do the conversion from ID to string in JS.
Why? Conversion is necessary for only the one row that is returned from randomized selection. The join unnecessarily complicates the SQL query.