2 ms·
We did a performe comparison on handling Geo data. SQL server came out on top.
by nimchimpsky 10y ago
We did a performe comparison on handling Geo data.
SQL server came out on top.
- Demiurge 10y agoIn what way? I can't even tell if you mean features or performance. PostGIS is unmatched as far as features, as far as I know.
- dx034 10y agoDon't know if the comment was edited, but it says performance comparison? (If I interpret the typo correctly)
- nimchimpsky 10y agoit wasn't edited
- dagw 10y agoWhile it is true the SQL Server is missing a fair number of features compared to PostGIS (and Oracle Spatial), I've always found that the spatial performance of SQL Server is been really great for the common features it does support.
- Demiurge 10y agoOk, thanks, that makes it worth checking out!
- nimchimpsky 10y agoI said "performe" a typo from my phone, you really didn't know that I meant performance ? Queries returned results faster in sql server, after checking we had set everything up optimally in everything.
- tracker1 10y agoThat's one area, where at the time (about 4 years ago), Mongo worked out really well for me... iirc there was a bug I experienced with ElasticSearch, and RethinkDB didn't have geo indexing yet. It doesn't surprise me though... MSSQL tends to do very well out of the box for most workloads.