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