About Client

ApartmentTrends by Austin Investor Interests, TX, US offers the most comprehensive apartment research data for the US cities Austin and San Antonio for multifamily housing markets, since 1994. AppartmentTrends is a company that collects, analysis and reports housing data for investors, brokers, managers, developers, planners and lenders. They collect data on a day to day basis and keep the database up to date. The collected data is published to the subscribers every quarter.

Requirement

The client was gathering multifamily housing apartment data for Austin and San Antonio and presenting the same to its subscribers. The information provided was mix of units, types of units, rents, concessions, amenities, absorption rates, authentic property ownership, sales and a host of other options for slicing and dicing the data to meet the urgent needs of customers. In addition to comprehensive overviews of existing multifamily communities, they were also tracking the development pipeline — who is building what, where and when — as well as which properties are on the market or have been sold.

Challenge

AppartmentTrends was using a Coldfusion application for almost two decades. As the data grew over the years, the Coldfusion server was not able to process the data. It started going down frequently, which led to repeated restart of the Coldfusion server and thus denial of service to the subscribers.

Solution

Since we have been working with Coldfusion applications from its very early stages, we understood the limitations quickly and suggested migrating the application to an open-source platform. The client was agreeable to our proposal.We successfully migrated the CF application to PHP Yii 2.0 and MySQL. Vue.js was used in a few areas to get a better User Experience. The solution is hosted in the Amazon AWS cloud.

Result

  • No server restarts

  • Faster report generation

  • Faster data processing

  • Reduced cost of ownership (by using open-source platform instead of proprietary Coldfusion and MS-SQL)

Conclusion

It is essential to evaluate and make the right decision about the legacy applications. Migrating the legacy programs to a newer technology platform could be beneficial from both a performance and cost perspectives.

location-icon

Location

United States

corporate

Industry

Multi-family housing data

mysql_icon

Function

Data Analysis and Reporting

Technologies Used

Are you spending more money and time in maintaining your legacy software applications?
We can help you evaluate and suggest the right solution.