I have a large number (100,000+) of vehicle GPS paths in a PostGIS database. I need access to all of them on my web page, however, I don't usually need to view more than a handful on the map at any one time.
Should I be making all of these paths into layers, or is there a better way to go about it? (Possible example: I'd love it if my JS client could request data for certain location and time frames, and GeoServer could dynamically make layers from the database data, serve those layers, and maybe get rid of them when finished.)
If I am making each path into a layer, is there a way to organize that many layers on the GeoServer admin page, rather than just a gigantic list?
Additionally, is there a way to organize how these layers are sent to my web page? The most helpful way would be to only receive the names of layers that could be viewable currently on the map, but I don't know if that is possible.