Browse by Tags

SQL Server 2008 Spatial - Performance of database calls follow up

I recently blogged about the performance of passing spatial data to the database.( SQL Server 2008 Spatial - Performance of database calls? ) In it I found that the the performance radically dropped off as the number of points increases. Whilst this was suprising I had used my usual approach of eliminaing...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 01-08-2008
SQL Server 2008 Spatial - Performance of database calls?

There are 4 ways of holding spatial data, Well Known Text (WKT), Well Known Binary (WKB), Geography Markup Language and the base spatial type (SqlGeometry or SqlGeometry). This leads me on to the question how should you pass the data to SQL Server. I've heard bad things about passing udts and so...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 01-07-2008
SQL Server 2008 Spatial - Which is faster WKT or WKB?

I've just posted two methods for creating geometries in client code. The examples use Stylus points from an ink canvas but any collection of points will go. After doing that I ran some tests to compare the two. I found that in generally the WKB method was ~70% faster to build the WKB and 40% faster...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 01-04-2008

Page 1 of 1 (3 items)

SQL Server Community Blogs