4 ms·
Should be running (a bit) better now, though likely still on the slow side. Turns out a query I'd written back when there were 20k votes in the system didn't p
by DRMacIver 15y ago
Should be running (a bit) better now, though likely still on the slow side.
Turns out a query I'd written back when there were 20k votes in the system didn't perform so well now that there are 200k votes in the system. Go figure.
- masenf 15y agoScale is always one of the most difficult things for me to plan for. Over last summer I was working on a registration system for an ISP which worked really well in testing. Once the database exploded to over 1M rows however, that application's performance was noticeably suffering. Unfortunately now that system is live, and the schema can't be changed for a few months...oops