I have a mysql database with +25K rows including geometry and other attributes. Using a mysql2geojson php script I then added it to a leaflet map.
It is super slow now, what can I do to boost the performance?
I'm using www.one.com as host meaning I dont have access to anything else than php/mysql. I can't get postgis/geoserver, etc.
I also intend to design a search filter limiting which points to be shown on the map. For this purpose, is it best to do new calls to the database, or should I be working against a "local dump" for the searching?
To summarize I wonder how to best work with big point data sets with mysql/php/leaflet including searching. Any tips are welcome!