Bastien Koert wrote:
Hi,
Ok, disk space is cheap, but you can't avoid the access/seek time penalty
on this.
- Unomi -
Properly indexed, its not that bad...after all its what Dbs do best
I only mention this, that while disk space seems a unlimited resource
these days the fact that a DB gets it's bottleneck here is paramount.
I suggest to look up articles about this on www.mysqlperformanceblog.com
to find some hints and tips to avoid most of the issues with huge disk
space and record access.
And BTW, 'properly indexed' is mostly easier said than done.
- Unomi -