I'm rebuilding a web app in Laravel for managing client portfolios.
One feature is to be able to pull up a client's account quickly, either by account name or id.
Previously I just pulled a list of all the clients and put them in a javascript datatable. This paginated them automatically and provides a nice search box but as there are around 300 clients and increasing this seem inefficient and unscalable from a performance perspective.
Requirements:
- Must be able to instant-search/filter for any client; Laravel's out-of-the-box pagination is unsuitable as it only gets a partial result. Some sort of ajax method might be better.
- Concise amount of output on the page.
One thought I had was to provide a search box which auto searches based on a partial input and outputs data for the closest matching client beneath as you type.
Any suggestions?