[postgis-users] Performance question (how many years will this take?)

[Andrea Aime]

Alle 04:04, martedì 11 maggio 2004, Wood Brent ha scritto:

...

> What I have now done is add a
>     "where cell_id >= $START_ID and $CELL_ID < $END_ID"
> into the sql, and wrap it up in a script which starts at cell_id of 0 and
> increments in batches of 100 cells per iteration until it gets to the
> maximum cell_id. (note: there is a unique index on cell_id which is an
> integer attr)

Sorry, but I've never seen that sintax... what's this and why it improves the
overlay process?
"where cell_id >= $START_ID and $CELL_ID < $END_ID"

Best regards
Andrea Aime