[Koha-bugs] [Bug 32493] Vendor store loads unpaginated vendor list on ERM module main page

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32493

Ian Walls <ian at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ian at bywatersolutions.com

--- Comment #1 from Ian Walls <ian at bywatersolutions.com> ---
I have a library with over 200K vendors, and this causes a 3.2 minute delay in
loading the ERM module, making it nearly unusable.

Would it make sense to use an on-demand autocomplete field here, instead of
loading and storing locally the complete vendor list?  After a user enters 2-3
characters of the vendor name, a paginated query is fired off to the API for a
list of suggested vendors.  Further entered characters further refine the list
of possible vendors.  see https://vuetifyjs.com/en/components/autocompletes/
for more details of how this is accomplished in Vue.

If the local storage of the vendor list is used for other parts of the ERM than
the vendor filter in the data tables, then perhaps a compromise could be made
to set the pagination at a reasonably high number that returns all vendors for
MOST libraries, but is still performant for libraries with a large vendor list.

-- 
You are receiving this mail because:
You are watching all bug changes.