Fellows, I need your advise:
I am going to use a page field to select (one or more) related products. Everything's nice with just a few products to select from. With a large number of products (say 5000) I am running into trouble, though.
When using a PageListSelectMultiple input field the user needs to browse through all ~100 columns of pages to find the desired entry.
When using an AsmSelect input field it is possible to type in the beginning of the desired entry, so it's fairly quick to navigate to the right entry. However, every page (in admin) with such AsmSelect loads with quite some delay because all 5000 page field references have to be collected first. It actually prevents a fluent workflow.
So, I wonder what's best practice to select from a page field with many entries, provided you know the name (or at least part of it) of the desired entry?
I don't want to spread the product pages into subfolders at the moment because this would affect a lot of other functions of the site as well.
I could imagine some text field where you can type in the beginning of the entry name. When hitting return a (reduced) page tree comes up with matching results. And if entering the complete entry name, the page would be added to the list of selected pages instantly, without displaying the page tree first. Does some method like this exist already? Other suggestions, anybody?
tia!
HerTha