Re: [SQL] how can i UPDATE without dead rows

2005-06-17 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Hi! My program must use UPDATE usualy, and there will be many dead rows in this table what throttle down the db server. I would like to update so not create dead row. How can i do this? You can't - that's how MVCC works. Make sure your free-space-map settings are l

[SQL] how can i UPDATE without dead rows

2005-06-17 Thread csepinek
Hi! My program must use UPDATE usualy, and there will be many dead rows in this tableĀ  what throttle down the db server. I would like to update so not create dead row. How can i do this? sorry for my english :)