LECCO Technology Ltd Addresses DB Performance Issues

Hong Kong-based software developer, LECCO Technology Ltd, has introduced a new generation of its innovative LECCO SQL Expert database tuning solution that can cut access time for Microsoft's popular SQL Server database product by multiple times and raise developers' overall SQL coding standard through it's "In-Process Training" mechanism.

"When companies look at improving the performance of their database systems, it usually involves upgrading their hardware platforms or increasing communications bandwidth. This is not only expensive, it overlooks the fundamental causes of system slow-downs -- database application," said Stephen Wong, president & CEO of LECCOTech. "The most effective way to increase system performance, is to optimize SQL statements exist in database application which can take up 60 - 70% of the system resources."

"However, simply fixing inefficient code provides a short-term benefit, and it can only be solved when the problem occurs but doesn't eliminate the cause of the problem -- inexperienced programmers who write inefficient SQL statements, over and over again," he said.

LECCOTech emphasizes what it calls the "In-Process" learning and training benefits that LECCO SQL Expert can offer. "Through using the product, users of different levels of experience can enhance their programming skills by watching the way in which in improves their SQL statements and then adjusting their programming style accordingly," said Wong. "The result is better quality code and more easily maintained applications, which in turn, means more satisfied customers especially for e-commerce companies that need every ounce of competitive advantage if they are to enjoy long-term success."

The latest generation of LECCO SQL Expert enables programmers to compare their code before-and-after tuning. They can improve their understanding of the process and raise the overall quality of their output during the application development process.

In addition to addressing the issue of improving the skill and quality programmers and programming, LECCOTech's new LECCO SQL Expert for MS SQL Server is expected to appeal to the increasing numbers of e-commerce Web site operators that are using the Microsoft database platform. By fine tuning the SQL statements that underlie each Web-based transaction, LECCO SQL Expert enables e-businesses to come closer to the ideal of providing a nearly-instant response to customers buying online.

"Increasing numbers of e-commerce Web sites are being driven by MS SQL Server database and the key to top Internet-based application performance is highly optimized SQL. LECCOTech's new LECCO SQL Expert product makes this easy with the world's first automated SQL tuning and optimization solution and can offer a significant competitive edge to dot-coms," said Wong.

"LECCO SQL Expert for MS SQL Server enables companies that choose the Microsoft route to enjoy a far higher level of database performance in the early stage of their business. Moreover, by fine tuning their SQL queries, they can postpone the day when they have to upgrade their hardware or even avoid that entirely!"

In real world tests at a dot-com company, LECCO SQL Expert for MS SQL Server improved the performance of SQL statements by 260 per cent, cutting response times from more than 10 seconds to 3.8 seconds.

"Response time is a critical factor for successful e-commerce Web sites so the source SQL that we tested was already very fast," said Wong. "However, by deploying LECCO SQL Expert for MS SQL Server the firm was able to speed up database performance substantially which translates directly into an improvement in the online experience for customers."

LECCO SQL Expert for MS SQL Server is available in two editions: LECCO SQL Expert Professional (Pro) comprises four main modules, including SQL Scanner, Syntactical Optimizer, SQL Formatter and Database Explorer. There is also a new feature that will allow users to activate SQL Profiler within the LECCO SQL Expert environment at the click of a button. Whereas LECCO SQL Expert Developer (Dev) comprises of three modules, Syntactical Optimizer, SQL Formatter and Database Explorer.

"Today, software development is fast paced and ever changing, and it is critical to develop innovative technology product to keep our competitive edge," said Wong. "LECCOTech has embraced this challenge mind, continuously research and develop innovative product and readily adapts to the changes of the market."

Established in 1995, LECCO Technology -- winner of the Hong Kong Computer Society's Gold Award for Product Excellence 1999/2000 & Technology Firm of the Year of National Business Incubation Association (NBIA), USA -- is an innovator in the field of database performance enhancement solutions. The company has received venture capital funding support from the Hong Kong SAR Government, including US$2.5 million from Applied Research Fund, managed by Walden International Investment Group and a R&D loan of HK$5 million from the Applied Research Council, US$1.15 mil from CTC and US$3.6 mil from Netalone.com. With its dedicated R&D and experienced management team, LECCO Technology is fully committed to advancing the Hong Kong's reputation as a technology innovator on the worldwide market.

Contact Emily Leung of LECCO Technology Ltd, +852-2527-0330, or emilyleung@leccohk.com, Website: www.leccosqlexpert.com.