u/wonkey_monkey

Just in case some people still haven't got round to it yet. No, it's not quite as good as the old one. Yes, he spends a lot of time going up and down the Five Mile Road. Yes, a decent chunk of it was filmed in England (but that goes for the first series of the original too).

Just take it as its own thing. You might enjoy it.

I just hope they finally get a local pronunciation advisor for series 3...

I have a large table, T, which consists of rows of report data for a small number of companies (<10). Each time I get a report, I insert its rows into the table, along with a company_id and a datetime.

I have a view, V1, which returns each company_id along with the maximum datetime for that company_id (i.e. the key needed to select the latest report per company):

SELECT company_id,MAX(date) AS date FROM T GROUP BY company_id

This view is fast.

I have a second view, V2, which joins T to V1 in order to return all the rows for all the latest reports per company:

SELECT * FROM T JOIN V1 USING (company_id,date)

This view is really slow. It takes about 4 seconds to run the query, and about 16 seconds to fetch.

If, instead, I take the results of V1 and build myself a manual query like this:

SELECT * FROM T WHERE
(company_id=2	and date='2026-07-17 11:03:01') OR
(company_id=3	and date='2026-07-17 11:09:01') OR
(company_id=4	and date='2026-07-17 11:07:01') OR
(company_id=8	and date='2023-06-15 12:05:01') OR
(company_id=10	and date='2023-01-01 00:00:00') OR
(company_id=15	and date='2026-06-15 23:10:01') OR
(company_id=16	and date='2026-07-17 11:11:01')

then I get the results in a fraction of a second.

company_id and date are both indexed, and they also have a joint index.

I can only assume that V2 is fetching all the rows of T and only then filtering them via the JOIN to V1.

Is there a way to speed up this view?

Then I remembered I don't wear contact lenses.

This one's driving me nuts.

You know how in Firefox, etc, you can do a two-finger pinch zoom (or pan/swipe) gesture on a trackpad, and you get a continuous accurate zoom fo the webpage? How can I get that kind of information into my C++ program?

I've come across things like "Interaction Context" and "Direct Manipulation" but it's confusing the hell out of me. Then there's stuff about WM_POINTER and WM_GESTURE messages, but I can't figure out if that's the right thing, or if they're deprecated, or what.

I just want my window to be told, somehow, about zoom and pan gestures. Or really just to be handed a scale and/or translation.

Could a kindly human being point me in the right direction?

Lately - since the update to 150, I think - I've noticed Firefox seems to, I don't know, "fall asleep" a lot, or something. I don't really know how to describe it, but I see things like this (but only fairly rarely, not every time):

• Pressing Ctrl-T and it takes half a second or more to actually open the tab, whereas before it was always instant
• Start scrolling, but it takes around half a second to respond (then subsequently acts normally)
• Open a minimised Window, and for half a second it's almost completely black, then it paints the page (a couple of weeks ago I was also catching it drawing old-style non-aero controls during this "wake up" period, but that seems to have been replaced with a blacked-out window now)

Has anyone else noticed anything like this?

I've got plenty of RAM and only have a few tabs open at a time. The only big thing that I can remember doing lately was disabling the Windows hypervisor so I could use VirtualBox, but I can't see how that would have affected things.

Since the upgrade to 150, my print dialogs, javascript dialogs, and "title" hover captions are all showing in a dark mode style (white on black or dark grey).

Is there any way to override this back to a light style?

I changed layout.css.prefers-color-scheme.content-override to 1 but with no effect.