28 ms·
First, consider the numbers: 20K ships * 5 times a second * (1 query + 1 transaction) = 100K queries + 100K transactions per second (each query returns about 5
by pron 14y ago
First, consider the numbers: 20K ships * 5 times a second * (1 query + 1 transaction) = 100K queries + 100K transactions per second (each query returns about 5 neighboring ships). And the point isn't sheer speed, but scalability. The point isn't running the simulation as fast as possible, but demonstrating the database's capabilities.
- krichman 14y agoBut it's also a valid point; it's important to know if it scales well for larger datasets. I think the premise is good, we need better tools for creating multithreaded, concurrent applications. Looking forward to your future posts.