About this Article:
It was once common knowledge among FoxPro developers to add an index tag on DELETED() to every FoxPro table. This was believed to improve performance. Chris Probst's groundbreaking article in the May 1999 issue demonstrated this added index tag caused serious performance problems. Now another common practice is causing far more significant performance problems:
using parameterized views. Although views are common, they introduce some problems that affect application performance and can be hard to detect and fix. Discover solutions to these problems.
Mike Yearwood is the senior systems analyst and owner of Fox Ridge Software Inc., a Toronto-based developer of custom desktop and web-based software for various industries. Mike has more than 25 years of experience in IT and has been developing with Fox products since FoxBase version 1.02. mike.yearwood at foxridgesoftware.com
Keyword Tags: Application Development, Database, Database Development, Development, IT Networking, Microsoft, Microsoft SQL Server, Microsoft Visual FoxPro, Performance, Software Development, XML