Hello,
I’m building an app using bubble. I decided to use the fuzzy search plugin to enhance the search function. The plugin is working perfectly on the development version but doesn’t work at all in the live version. I could also add that the live version has almost 10,000 records in the database. Could this be the issue?
1 Like
Hello @joancindi535, 
I’m sorry to hear you’re experiencing issues with the plugin. The difference in behavior between the development and live versions can be related to the data in your live database. Here are some steps and considerations to help resolve the issue:
- Ensure that your development version, including all workflows related to the Fuzzy Search plugin, has been fully deployed to the live environment.
- Please verify that your live database is not empty and that it contains the records you expect to search through. Sometimes, the development database is not automatically copied over to the live database on deployment.
- With a large dataset like yours, indexing may take some time. The first search in a large dataset can be slower as the plugin indexes the data. Subsequent searches should be faster.
- Check the data privacy rules in your app’s settings. Ensure that the live version has the correct permissions set up to allow the plugin to access the data.
- Revisit the plugin settings and ensure that all necessary API keys and configurations have been properly set up in the live version.
- Look at the error logs in the Bubble editor and browser console for any errors that could provide more information about the issue.
If you’ve confirmed that your live database is populated and you’re still encountering issues, you might want to try redeploying. It’s possible that not all changes were pushed to the live environment during your last deployment. After deploying, test the search function again in the live version.
I hope these suggestions help you troubleshoot the issue. If you need further assistance, please let me know. 
Best Regards,
Daniel
Hey Daniel,
Thank you for your response. I have gotten the plugin to work on the live version of my app. However, there is a problem, whenever I run a query on the search bar, it takes a long time to bring the result. After showing the results of my query, my app crashes.
Is there a limit on the number of rows of data allowed for the plugin to work efficiently?
I’m looking forward to your response. Thank you in advance!
1 Like
Hello @joancindi535,
I’m glad to hear the plugin is now working in the live version of your app. Performance issues with large datasets, such as long query times and crashes, are more common when dealing with a high volume of data. The best way to proceed with such an amount of data is to use third-party storage, like Algolia, AWS, etc. After that, you can retrieve the data to the Bubble. It’s also important to note that the performance of our plugin depends not only on the number of records but also on the “fat content” of the object, such as the number of search fields. In some cases, a larger table with fewer search fields might perform better than a smaller table with more search fields. While the amount of information does impact the speed of search, it’s not the only factor to consider. It may be a lack of server capacity for your app also, or a slow device, on which you are running your app with the plugin.
Please allow me to propose you create your Custom State, which should retrieve information from the database, and you can search using this Custom State. You can try to create an action (when the page is loaded, or on click event, does not matter) and add the custom state to your page. This custom state’s value will be your database result. By this, you will call for the data and let the plugin understand which exact data array to use for the search.
Then, indicate into the plugin data source, not the actual data but the page’s custom state (which value will include your data).
You can also consider our Fuzzy Search Pro plugin as data processing within the plugin was improved by our developers in the pro version. You can subscribe to it for testing purposes within your app and unsubscribe after a day or two (in case it won’t satisfy your use case). You should be charged only for the number of days you used the plugin.
I hope this helps! 
Best regards,
Daniel.
Thank you for your help. I will try implementing your solution!!
1 Like
Hi @joancindi535,
Glad to be helpful. Please feel free to reach us again when you need some help or assistance. It will be a pleasure to cooperate.
If our plugins are making a positive difference in your projects, consider leaving a rating. You can do this by visiting the Plugins tab in the Bubble editor, searching for our plugin, and giving it your star rating. Your support would mean a great deal to us!
Also, if you feel inspired to share your whole experience with Zeroqode, you’re warmly invited to write a review at Review. Your insights are precious, not just to us but also to the wider Bubble community, and they inspire us to keep improving our service and offerings.
Thank you once more, and if you ever have more questions or need further assistance, don’t hesitate to reach out. Wishing you a fantastic day ahead!
Warm regards,
Daniel.