I think big data is measured in TB, especially when it comes to OLTP. I know that people might disagree, but that’s what I think. I’m sure that it’s bigger for BI and even bigger for social media feeds, but for me – managing TB’s of OLTP data gives some head aches.
I’ve blogged before on large tables in JDE, and how large their requisite indexes are. Here is an AS/400 example
- F0911 90GB
- F0911_1 6GB
- F0911_28 6GB
So, 90GB of data and around 140 GB of indexes for F0911. This is with 610GB of data. A fairly normal mix I’m here to say! I feel for the web server if someone wants to “scroll to the end” of the F0911 table in data browser – ouch! That’s going to crash.
No comments:
Post a Comment