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!
You might try a clustering strategy such as the Leaflet Marker Clustering plugin - https://github.com/Leaflet/Leaflet.markercluster
You can see an example of this at work here - http://leaflet.github.io/Leaflet.markercluster/example/marker-clustering-realworld.388.html
Here are a couple of thoughts on what you can do to boost performance:
Ideally you would generate tiles for this large of a load, but the previous pointers should help guide to better performance.
maybe we can use mysql index to load 1000 rows each at a time..Logically its almost same as map tiling