Re: slow update & index question

On Mon, 21 Oct 2002, Williams, Travis L, NPONS wrote:

> I have a script that is updating the DB by reading in a file with 467
> lines. Each file is named by the shelf the information was gotten from.
> Each line is tab seperated and consists of a column name and the value
> that it should be update to. The update line in the perl script looks
> like this: update table set "column name" = 'value' where "Shelf_Name" =
> '$shelf'
>
> Now this works.. but it takes almost 1 minute to do the updates. With
> nothing else at all touching the DB.. is this normal? The DB is
> index'd on the Shelf_Name column.. but how do I know if it is using the
> index.. or does that not even matter in this case?

Try putting a begin; and end; command around your updates, so that they
are all one big transaction. That should speed things up.