いくつか事例も掲載されていますね。3,000万人の患者情報を管理しているのか。In-Memory 機能を使って毎秒 34,700トランザクションで、今までより 7倍。すばらしい。
TPP, a clinical software provider, is managing more than 30 million patient records. With In-Memory OLTP, they were able to get their new solution up and running in half a day and their application is now seven times faster than before, peaking at about 34,700 transactions per second.
Based on Microsoft SQL Server 2008 R2 Enterprise software, SystmOne manages more than 30 million patient records, which equates to more than half the population of England. There are 200,000 active registered users from the National Health Service (NHS) on the system in the United Kingdom, with a peak concurrency of more than 72,000 users.
TPP also had to maintain or exceed the solution’s extremely fast response times. “SystmOne delivers patient records to doctors in 250 milliseconds on average,” says Grayson. “In the United Kingdom, where doctors typically only get five minutes with a patient, that sort of response time is critical. In the most extreme scenario, if a doctor can’t access the system fast enough, patients’ lives could be at stake. The speed of the system is essential.”
どのようなテーブルに、In-Memory を適用したのでしょうか。気になるなぁ。ああ、早く 2014 にしてしまいたいです。