UK’s Leading Provider of Share Transaction Analysis Migrated from Microsoft SQL to Sun’s MySQL Enterprise, Reducing Processing Time from Six Hours to 90 Minutes
Directors Deals Ltd, has migrated from Microsoft MS SQL to Sun’s MySQL Enterprise in order to increase the speed and efficiency of its processing time. With MySQL, the world's most popular open source database, at the core of its business, Directors Deals is able to process 600,000 company share prices per day, and reduce the processing time of its company price import process from six hours to just 90 minutes. Directors Deals now operates its entire business on a Sun MySQL Enterprise subscription.
Directors Deals monitors and analyses share transactions made by Directors in their own companies in the UK, Europe and the US. Sometimes known as Insider Deals, these are reported to international Exchanges or financial supervisory bodies such as the London Stock Exchange and the Securities Exchange Commission on a daily basis.
Directors Deals checks, supplements, and analyses this data on behalf of its subscribers. The company supplies succinct, contextual and detailed reports to enable clients to make more informed investment decisions. Clients, such as The Financial Times, Fidelity, Merrill Lynch, Citigroup, Scottish Widows Investment Partnership, Barclays Global Investors, Gartmore Investment Management, HBOS, and Schroders Investment Management, use Directors Deals content to find new investment opportunities, analyse the success of existing investments and to add context and background to their services and publications.
“We track between 60,000 to 80,000 announcements a week from which we create reports of significant transactions,” said Dave Wright, Senior Programmer for Directors Deals Ltd. “Clients of our products and services include some of the biggest names in the UK financial services arena, who have a constant demand for the latest analysis on share transactions and trading. We process approximately 1,000 transactions a day, and analyse the share prices of around 600,000 companies daily. Previously, we were using Microsoft SQL. We used to run our company price import early in the morning as it would take more than six hours to process. With MySQL, these same reports run in about 90 minutes. We can now have our price import finished early in the morning before anyone starts work.”
Wright and his team migrated to MySQL in October 2006 as performance of the Microsoft SQL database was becoming an issue with regards to the volume being processed. The company now supports 170 users.
“I had used MySQL before and was very impressed by it,” added Wright. “From my experience, I knew that it would be painless moving from Microsoft SQL to MySQL. The main thing for us is the security of the MySQL Enterprise Edition. We know it is a fully supported and fully tested product, while the community version has its uses and is stable, but for a critical system like ours, the real value is knowing that we have someone there at end of phone should a worse case scenario happen. Support is also a business assurance requirement mandated by our board.”
MySQL enables users to cost-effectively manage explosive growth in their businesses through innovative database products and commercial services based on proven best practices. The MySQL database server is a recognized platform of choice for a modern “Scale Out” application architecture -- replicating multiple database servers on low-cost commodity hardware.
MySQL Enterprise is a comprehensive subscription, consisting of production-tested software, proactive monitoring tools, and premium support services.
For further information, please contact:
Tel: + 44 (0)203 239 9722
This press release was distributed by ResponseSource Press Release Wire on behalf of Devonshire Marketing in the following categories: Business & Finance, Computing & Telecoms, for more information visit https://pressreleasewire.responsesource.com/about.