When Using STUnion to construct a polygon, is it faster to do it on code or let the Database handle it?

Question

I was just wondering which is faster:

Constructing a wkt polygon using SQLGeography's STUnion method.
Constructing a wkt polygon using the STUnion method built into MS SQL Server.

I only ask because I wanted to be sure. I'm assuming that if I went with 2, querying and constantly updating the database would increase the amount of time it takes to process/create the data. This would be through one connection so there wouldn't be a need to reconnect every time something needed to be added.

score 0 · Accepted Answer · answered Mar 14 '12 at 18:53

0

I did some benchmarks and constructing the polygons using the STUnion method in C# was at least twice as fast.

answered Mar 14 '12 at 18:53

avtoader

63
1
8

When Using STUnion to construct a polygon, is it faster to do it on code or let the Database handle it?

1 Answers1