💾 Archived View for station.martinrue.com › marginalia › 086a854c52354e4dab80ca8d7bc1b875 captured on 2022-07-16 at 15:08:04. Gemini links have been rewritten to link to archived content
-=-=-=-=-=-=-
My URL database's is such a chonky boi, it takes 50 mintues to drop a column of ints.
7 months ago · 👍 aka_dude
90 million rows give or take. Probably would have been faster, to recreate the table, but this worked. I'm doing some normalization because it's a very wide table, and the access pattern doesn't really justify how denormalized it is. The design had a lot of drawbacks and not a lot of benefits... · 7 months ago
how big is the table? Would it have been quicker to create a new table and select/insert into it? · 7 months ago
SELECT COUNT(*) ... 30 seconds. This is fine. · 7 months ago