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