So I'm working on a solution for a client that needs to have people organized by state/county. So I set up connections to have 51 parent categories (states), and their counties. I wrote a script to very carefully load these into the connections databases.
Currently there are 3150 categories, and as much as I would like to reduce this number I can't. I've had to modify the max_execution_time to be a full minute in order to get the connections plugin to load its category list. Furthermore once it does load the page hangs for quite a while before I am able to interact with it.
On the front end there is a dropdown where users pick state, then county, and it shows all the entries that match.
Is there a way that categories could be streamlined a little bit more? Or perhaps better organized (paginated?) so that individuals who need a lot of categories can use your plugin? Or is there a better solution using this plugin that I am not aware of. I am open to suggestions.