This client was storing medical records with some fields being over 32,000 characters. Other fields held references to lists of descendant or predicate medical devices. Queries to find any device that was a descendant/predicate of another device OR queries that searched the full text were timing out.
The solution was to migrate all data to Xano and to index the data appropriately and implement a Fuzzy Search feature to greatly decrease query times to as low as 3.8 second for the same full text searches.
Client was able to save over $200 USD/month by not using Algolia/Elastisearch while maintaining optimal query times for their clients.