64-Bit Beckoning
It's all well and good, of course, that the test is giving Townsend a taste of the efficiencies of WMI integration, along with the advantages of better security. As stock tickers keep clicking along, however, a realtime trading service such as RealTick requires absolutely realtime database performance.
Nobody knows this better than Lewis, who is still waiting for Microsoft to add its promised 64-bit edition, along with multithreading of more database tasks.
"Data loading transfer jobs can (already) be multithreaded. At the moment, I'm most concerned about multithreading the data mirroring, which is still singlethreaded," Lewis says.
"And we certainly will test the 64-bit mode of SQL Server 2005 whenever it does become available. Our expectations are to improve the performance/run-time of our many very high-volume data repositories. We still haven't seen the 64-bit mode yet, but we understand (from Microsoft) that 64-bit is almost here."