Bit of a theoretical one this, but I was wondering if anyone had tried to use CartoDB and Torque with any big(ish) data. What I am talking about is having the location of 75,000 people at 1 minute resolutions for a 24 hour period. Would torque 'work' or would it just crash? I've done it successfully with 200 people, but am now getting to the stage where I'll want to test this with much larger datasets.
We have done torque visualizations of 3,000,000+ points a few times* with no problem. We are also researching specialized indexes for tables used in torque visualizations that would make it even faster. That said, 100 million is a huge dataset. On the server side, torque can be a memory intensive, so I imagine you will hit the limit before this.