0

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

null
    • Fred
    • 1 mth ago
    • Reported - view

    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.

    • John_Halls
    • 1 mth ago
    • Reported - view

    Form what you have said

     said:
    lag while filling out forms

     It 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