I saw nothing that said "Audio Service Started" and I just downloaded the latest moments ago. Open-GL version posted 23 hours ago. Fully up to date with latest orbiter and setup script.
It does seem to change orientations nicely. I cannot select a different skin. Power button craps it out pretty badly. Cannot show remote screen. Just goes to background. I can hit back to go back to the main screen. Media grids load. Many other functions seem to work.
So, going to San Francisco in a couple weeks? Sounds like fun! I'm just down the road a little from there and spent the day there during the America's Cup on one of the final days. That was fun.
as far as the threads, well its a lot of moving parts and im still not settled on the current implementation.
Smokey mostly. It works fine sometimes but generally is very slow. It is happening right now with the latest version. It looks like it switches but forgets to do a redraw until the next background image shows up. That's been my experience and what is happening at the very moment.
I've noticed one small problem when I rotate the screen: it hours to a black screen and can take upward of 10 seconds to return to a functional state. Sometimes it never returns or I get too impatient and never see it return. Is there any option that forces the screen into landscape mode?
Inner joins (or left outer joins) are the way to go here to speed up this chunk of code. If you need to implement some logic that doesn't work with just a simple join, subqueries are MUCH faster if executed as part of a stored procedure. I try and keep logic away from the SQL server but I've had to do it in many locations and it improves performance dramatically. The logic here seems simple enough to not have to resort to a stored procedure though.
Also, once you have the query written, write a specific index just for that query. Do you need help writing the query? If so, just give me a list of the columns necessary and I'll put together a query for it.