[–] apu 14y ago ↗ Uh, what? [–] AznHisoka 14y ago ↗ I think this is a legitimate question. I always wondered the same thing.
[–] maxdemarzi 14y ago ↗ Because you are keeping 13 months of phone call data and want to easily drop the oldest month every 1st.Because your queries need to be fast, and you can chop up your data into 1000 pieces (by some column or combination) without adding complexity. [–] matc 14y ago ↗ You can easily drop the oldest month every 1st using a delete statement.Queries can be fast with indexes without adding complexity.
[–] matc 14y ago ↗ You can easily drop the oldest month every 1st using a delete statement.Queries can be fast with indexes without adding complexity.
4 comments
[ 0.18 ms ] story [ 28.7 ms ] threadBecause your queries need to be fast, and you can chop up your data into 1000 pieces (by some column or combination) without adding complexity.
Queries can be fast with indexes without adding complexity.