On 20.04.2006, at 18:10 Uhr, Radovan Antloga wrote:
I have once or twice a month update on many records (~6000) but not so many. I did not expect PG would have problems with updating 15800 records.
It has no problems with that. We have a database where we often update/insert rows with about one hundred columns. No problem so far. Performance is in the sub 10ms range. The whole table has about 100000 records.
Do you wrap every update in a separate transaction? I do commits every 200 updates for bulk updates.
cug -- PharmaLine, Essen, GERMANY Software and Database Development
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
