[Milhouse]

Debug log shows it takes a little more than 30s to display the Album view.

Yes, but some of that 30 seconds will be spent waiting for the SQL query to complete, with the rest spent caching the resulting data, before the UI displays the library. If the majority of the time is spent caching the query result then you're most likely wasting your time optimising the database further as it's not a db problem.

Edit: It appears that the CArchive timing information is somewhat inconsistent in Helix, which is a bit of a bummer.