My URL database's is such a chonky boi, it takes 50 mintues to drop a column of ints.

4 years ago · 👍 aka_dude

Actions

3 Replies

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... · 4 years ago

how big is the table? Would it have been quicker to create a new table and select/insert into it? · 4 years ago

SELECT COUNT(*) ... 30 seconds. This is fine. · 4 years ago