Had plenty of shitty query optimizations from MySQL.
But besides that, how much mb are 100million?
And what is your goal?