💾 Archived View for station.martinrue.com › marginalia › 086a854c52354e4dab80ca8d7bc1b875 captured on 2024-07-09 at 01:00:09. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2023-07-22)
-=-=-=-=-=-=-
My URL database's is such a chonky boi, it takes 50 mintues to drop a column of ints.
2 years 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... · 2 years ago
how big is the table? Would it have been quicker to create a new table and select/insert into it? · 2 years ago
SELECT COUNT(*) ... 30 seconds. This is fine. · 2 years ago