Hey, I still love GMS - thanks for your work on it.

I naively started to use FULL JOIN to join a bunch of large tables recently. 5000 rows, FULL JOIN to 15000 rows, FULL JOIN again to 700 rows, FULL JOIN again to 200 rows.

This was painfully slow. (I eventually realised I could rewrite this by adding an additional CTE at the start, and then using LEFT JOINs instead).

I feel like I was given enough rope to hang myself with here. As:

• MySQL typically doesn't actually support FULL JOIN, and

EDIT: Postgres is 100x faster, even with no indices on the tables

• (削除) GMS doesn't use Indexes during querying (削除ここまで)

(削除) My feeling was that an efficient FULL JOIN would use Indexes (but maybe I'm wrong) (削除ここまで)

(削除) I think I'd suggest removing FULL JOIN from GMS, so that: (削除ここまで)

• (削除) It's more consistent with MySQL, and (削除ここまで)
• (削除) You remove this performance footgun, while indices are still not supported. (削除ここまで)

Do you think you could speed this up?