Post reply

Improve Between performance

  • June 23, 2010 at 10:40 am

    #1184082

    Glad to hear that it works.

    From your posted results it should be possible to improve the performance even more.

    You only have 1800 grid squares but the most dense squares have over 37000 rows each. The goal is that the number of squares should be slightly larger than the number of rows in the most dense squares.

    Try setting @d=20000 in my original script to get a more even distribution.

    Good luck

  • June 23, 2010 at 10:53 am

    #1184092

    I'll give it a try...

    I just tried it and I got this error...

    Msg 8115, Level 16, State 2, Line 4

    Arithmetic overflow error converting expression to data type int.

    The statement has been terminated.

    I'm guessing 20000 is too low of a value 🙂

Viewing 2 posts - 31 through 31 (of 31 total)

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