Pluggable Search solution for legacy Enterprise Application
Pluggable Search solution for legacy Enterprise Application PROBLEM STATEMENT : A company had been using a 15 year old legacy platform for their business. Over the years the application became slow, especially during their peak season. By closely looking at the system, we found out that search queries in SQL database were taking more than an hour when the system was under the peak load since the data has grown to large volumes over the years. SOLUTION : After much deliberation, team came up with a solution to supplement existing system with AWS Cloud Search. The idea was that the legacy Database becomes the single source of truth and the AWS CloudSearch can be used for searching purposes. That meant, we dont use the legacy database for search purposes. The data was too large to be efficiently searched in SQL db. Hence, AWS CloudSearch would enhance search capabilities of the system. To further explain the new modified system : 1. Legacy Application : ...