Subject | very slow commit |
---|---|
Author | svanderclock |
Post date | 2010-02-09T12:26:21Z |
hello,
I update one row in 10 tables with a lot of index. (around 300 index to update)
to insert or Update the data it is very fast (around 100ms)
but, when i commit the SQL, it is very slow (around 3 to 6 seconds!). i see also that my hardrive is use a lot in the commit.
how to speed up the commit ? is it a normal behavior ?
thank you by advance
stephane
I update one row in 10 tables with a lot of index. (around 300 index to update)
to insert or Update the data it is very fast (around 100ms)
but, when i commit the SQL, it is very slow (around 3 to 6 seconds!). i see also that my hardrive is use a lot in the commit.
how to speed up the commit ? is it a normal behavior ?
thank you by advance
stephane