Full Long-Text Queries

OpenClose

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.

Millions of Records

OpenClose

This client is a nation wide distributer of a wide variety of items. They were moving off of their old platform and building a new interface on using Bubble. While the data imported fine, their queries were taking 10-20 seconds due to the sheer volume of data and types of historical queries being implemented. In addition, background tasks needed to be ran weekely to update the data for the last 12 weeks. This process took 2.5 days and consumed large amounts of system resources.

The dataset of 5 million + records (and growing weekly) was moved to Xano. Background tasks to rank products based on a sum of their sales for the last 12 weeks were created. With these tasks on Xano, the Bubble apps resources were freed for user interaction. The same tasks complete in 2.5 hours.

Client was able to save $300 USD/month by moving down a plan and using Xano. In addition performance engancements were observed with 1 second query times.

Location Laws

OpenClose

Client was building an app for students living in Canada. Per canadian privacy laws, any student data must pysically live in Canada, ergo any cloud providers resource center must also exist in Canada.

Client opted to use Google's Firebase Firestore as the backend. A custom coded solution was created and tied in with the clients Bubble front-end. Database design and security rules were managed by our team. In the end the client was handed back their app with a Lightning quick backend that physically existed in Canda and complied with the required safetly laws as they pertain to student data security.

Database & Backend Migration