Post reply

Best column type to store vector of doubles

  • February 15, 2011 at 12:44 pm

    #245654

    Hi,

    I would appreciate advice on what would be best column (data) type to use to store vector of doubles to optimize retrieval speed.

    Thank you

  • February 15, 2011 at 1:20 pm

    #1287286

    Before making your decision you might want to read these 2 articles on SSC.

    http://www.sqlservercentral.com/articles/SQL+Server+2008/64601/

    http://www.sqlservercentral.com/articles/Spatial+Data/64734/

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • February 15, 2011 at 1:24 pm

    #1287290

    First reaction is use 2 columns of type float. There may be specific reasons to use other means, however. Without knowing the specifics it's hard to give a better answer.

  • February 15, 2011 at 1:45 pm

    #1287304

    Thank you for replies.

    I need to store collection of doubles of variable size ( from 1 to 10000). It seems that Geometry data type in combination with MultiPoint class can help me if I can figure out how to use them.

    I would appreciate if you can make a few examples for on how to write/read data to/from such field

  • February 15, 2011 at 3:39 pm

    #1287352

    Disclaimer: you haven't given enough info to give a decent answer, and I question whether geometry is the best choice here.

    That said, look here

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply