Ken W
03-15-2000, 10:33 PM
"Chad Hegerty" <chad@hegerty.com> wrote:
>>> Try to filter the set of records U need to update at one time by using
one column. It might help the updating time..
>
>You should look at also taking a table level lock to start. You are spending
>some time taking lots of page level locks and, at least on 6.5, we have
seen
>where the page level locks will not escalate to table level.
>
>"Bean" <rl6@hotmail.com> wrote:
>>
>>I run a simple statement:
>>
>>update myTable set myDate = Null
>>
>>There are 66 thousand rows in the table "myTable".
>>
>>It took more than 50 minutes to complete. Is there any way to improve the
>>speed?
>>
>>Thanks
>
>>> Try to filter the set of records U need to update at one time by using
one column. It might help the updating time..
>
>You should look at also taking a table level lock to start. You are spending
>some time taking lots of page level locks and, at least on 6.5, we have
seen
>where the page level locks will not escalate to table level.
>
>"Bean" <rl6@hotmail.com> wrote:
>>
>>I run a simple statement:
>>
>>update myTable set myDate = Null
>>
>>There are 66 thousand rows in the table "myTable".
>>
>>It took more than 50 minutes to complete. Is there any way to improve the
>>speed?
>>
>>Thanks
>