I need to access a longish selection list. It is presented to the user in a drop down of checkboxes. The user can also just type to select so I need access to the list (for searching purposes) making it not suitable for streaming. I have two options:
Hit database once and store entire list in socket and use that to do searches and to display checkboxes.
Do a database hit every time I need access to the entire list.
How big a list are we talking here? I don’t think efficiency in this case is as important as what you can get away in terms of simplicity. Especially if the list is part of a form storing in assigns has the least amount of ceremony (none). You should only worry if there is actual concern about running out of memory. I don’t know much about your usecase, though.
Is this dropdown on an always visible element, like in sticky liveview?
How often will it be interacted with?
How often is the page that it lives on visited?
If it lives on the primary page of your app and you have 100,000 users constantly interacting with it, then you’ll probably want to try out one of the suggestions above. If it’s on something like a settings page, storing 700 text entries in the socket isn’t so bad at all, even if you do have 100,000 users. There are a lot of variables! I’d say just do the easiest thing until it’s a problem (ie what the gorilla said )
You’ve made me realize I’m overthinking this and worrying way too soon about performance. It’s all working using the socket so I’ll just leave it there for now and look into both the Agent or localCache at another time. Thank you @sodapopcan for that info about when to switch out of a socket solution. The list is in a drop down on the main liveview so it’s going to get loaded a lot. So I’ll keep in mind that neither the socket nor the database is a good long term solution. I’ll evaluate the other options when a) I’ve deployed and b) I’ve hopefully got enough users for it to be a problem.