On Sep 11, 2007, at 12:24 PM, Michael J. Babcock, MCP wrote:

> IAC, I thought I had heard that doing a SET ORDER TO on a network

> table

> was slow or caused a performance hit, especially since all we want

> to do

> is use the index to check for the existence of a condition that could

> nowadays be done with the SEEK(a,b,c) function. While refactoring,

> should

> this be done (...replacing the old SET ORDER plus SEEK command with

> the

> SEEK function instead)?

You should know the answer by now: test both versions under actual

network conditions. There is a good chance that the current code is

not noticeably slower than the proposed new code; if so, you've just

saved a bunch of rewriting.

-- Ed Leafe

-- http://leafe.com

-- http://dabodev.com