The Farber Consulting Group Inc.

Founded in 1992, The Farber Consulting Group, Inc. brings more than 30 years of software development and database experience to business systems. Our project history includes Johnson & Johnson, Dassault Aviation, Avis Car Rental, iA American Warranty Group, and VTP Ltd. in the UK.
Our work ranges from custom accounting and financial systems to aircraft maintenance scheduling, application modernization, web scraping, and complex database performance work.
The iA American Warranty Group project provides a particularly relevant example. We tuned more than 800 stored procedures and functions, improving performance across nested functions by 45–80% without changing the application code.
Large collections of stored procedures and functions can develop complex dependencies over many years. Changing one component can affect several business processes, so performance tuning needs to consider both database behavior and expected application results.
Our stored procedure optimization case study describes the work behind this project. We investigate query structure, repeated calls, indexes, execution behavior, CPU use, and database reads to understand the source of performance problems.
The goal isn't simply to make one procedure run faster. We want improvements that preserve the business behavior employees depend on. This work can also provide a useful starting point when a company plans a larger application modernization or database migration.