INSERT INTO is better because the index file is only locked and updated once. Having said that, if you are using Buffered views or tables, it probably doesn't matter. Updating the buffer is no big deal and the network is hit only when you TABLEUPDATE().
>Hi all,
> We've just installed our first Mere Mortals application at a client location, and we're finding that some processes are running slower there than in our development environment. We're now in the process of trying to optimize our application as much as possible before we start blaming the network, and one item we're looking at but can't seem to agree on is whether we should be using append blank or insert into to add a record. We encountered some problems using insert into in one of our conversion programs because newid() wasn't firing. I know that append blank is being used in MM classes, so is it safe to assume that append blank is recommended/required by MM, and if so, why?
>
>TIA,
>Rita Cargill
>CMi Software