Challenges with Optimizing Multi-User Data Entry in Ninox
Hello
I am currently working with Ninox to manage a database where multiple users are simultaneously inputting data; but I've encountered performance slowdowns and data conflicts. Specifically; users sometimes experience lag while filling out forms, and there are instances where changes don't sync in real-time. This has led to inconsistent data records and a less efficient workflow.
I have tried implementing various solutions; such as optimizing the database schema and using Ninox’s built-in scripting functions to streamline processes, but these issues persist. Has anyone else faced similar problems with multi-user data entry? Checked https://docs.ninox.com/en/tutorial/basics/working-together-on-databases-mongodb documentation guide for reference .
Any tips or best practices for improving the system’s responsiveness and ensuring smoother collaboration across teams?
Thank you !
2 replies
-
I don't have much to add as I am the only user of my DB, but I know at Nioxus has multi-user templates that you can get with a subscription.
-
Form what you have said
said:
lag while filling out formsIt sounds like it's not so much an issue about multi-user but a deeper issue. Are you using a lot of triggers and/or select statements? In a multi-user environment, and at any time, I would keep the architecture of your database as simple as you can, for instance
- use relationships in place of select statements.
- In a table with 20 fields a table level trigger could fire 20 times per record as you fill your data in. Use field level triggers over record level triggers, or use a button to do the job.
- Use dashboards to help fill in and display sub-sets of your data
I hope this helps
Regards John
Content aside
- 1 mth agoLast active
- 2Replies
- 60Views
-
3
Following