Loops on or off before I reach it in the current track

Also if Denon are using an ORM to access the database this could cause issues as well if left on default settings - the worst offender I’ve come across so far is Entity Framework (both EF and EF Core). Both require serious tuning and should not be left on default settings.

ORM’s have a habit of making far more database calls than necessary, made even worse if lazy entity loading is enabled. Some can also struggle to translate written code into SQL and resort to pulling most of the table into memory, then filtering, sorting and grouping the full list instead of doing this on the database side.

As you can imagine, grabbing 10000 items from the database then processing them further in memory rather than grabbing a much smaller subset of data and displaying that directly leads to huge performance issues if the dataset is big enough, or the query being executed is particularly complex.

2 Likes