Searching Database

Need help Database
1

Hi Everyone, I am sure there are multiple posts and questions about this, but I just wondered if someone can help on the best way to structure the database.

Currently, where I have a many to many relationship, I use a joining table and then front end I have a ‘Do a search for’ - so for example I have an activity table, which holds the user, I then just present this front end with the constraint of any activity that equals current user.

Is that the best way of doing it? Or would it be better to store those activities on the user record as a list, then present as a list of Current User’s activities?

The two things I am mindful of (as I am sure everyone is), is the speed and also the workload.

Thanks,

Graeme

2

The former is far better than storing the list of activities to the user data. The user data is loaded on every page load so it would definitely impact WU esp if your users have lots of activities.

Doing a search for with the user as a constraint is better since you’re only searching for data that you need when you need it.

1 Like