Gyanmandir Library - Sanskrit Book Database

The client's application struggled with performance due to the size of the dataset — more than 2 million book records, all written in Sanskrit. The SQL Server backend was unable to efficiently manage search queries at this scale, resulting in significant delays and long wait times before results appeared. A second major challenge was search accuracy: users frequently entered incorrect or incomplete book titles, but the existing search lacked tolerance for minor errors such as spelling mistakes or partial inputs. Searches failed when users did not provide an exact match, causing frustration when they couldn't retrieve relevant books despite minor input errors.

To resolve the performance bottleneck, Elasticsearch was integrated as the primary search engine, replacing the traditional SQL search approach. Searches that once took an excessive amount of time were now carried out up to 10 times faster, providing users with a far more responsive experience. To address inaccurate and incomplete queries, Elasticsearch's advanced fuzzy search capabilities were leveraged — enabling the application to retrieve relevant results even when the user's input was not an exact match, accommodating spelling mistakes and partial titles with ease.