> As for MySQL, if the table that you are inserting to has any indexes at
> all, then each time your insert/update completes MySQL will re-index the
> table.

That'll happen for any database (I don't know that it really re-indexes,
rather it has to update the index instead).

> Therefor, if you can batch the data like Rob suggested, then it will cut
> down on the number of re-indexes and speed the process up substantially.

Only postgres 8.2 supports that syntax so that may be another caveat

--
Postgresql & php tutorials
http://www.designmagick.com/

On Fri, 2007-09-21 at 08:42 +0200, Per Jessen wrote:

> Isn't that just an ALTER ?

Its a little more complex than that, as I have to actually create WKB
from the data, so no, not just an ALTER unfortunately.

--Paul


All Email originating from UWC is covered by disclaimer http://www.uwc.ac.za/portal/uwc2006/...imer/index.htm