Inside my Stock Control application i have a model variable type ArrayCollection which contains a list of Materials from my database.
When i login, i get the list from database and update the array with the content.
But it takes long time at the login process, which is unnecessary if the user doesn use the dropdows of material name to filter any information. And also the list is not updated in case other user inserts a new material in the system.
Is there any way to have the list populated from database when the user types 2-3 chars of the descrition for example, instead of have it populated at login process ?
What's the best way to have this kind of information in an application ?