Subject | commit after insert is very slow |
---|---|
Author | svanderclock |
Post date | 2010-03-02T20:31:49Z |
hello,
i already ask this question but as i don't resolve yet the problem, i try to ask it again
when i execute some SQL, the time to execute the sql is very fast (16ms) but the time to commit the data is very very slow (2293 ms, even some time more than 10 secondes !)
Time to execute the sql: 16 ms
Indexed Read: 117
Non Indexed Read: 0
Inserts: 30
Updates: 0
Deletes: 30
Time to commit the data: 2293
the tables where the record was inserted/deleted have lot of indexes (around 30 index by table, and around 10 columns by table)
thanks by advance for your help
stephane
i already ask this question but as i don't resolve yet the problem, i try to ask it again
when i execute some SQL, the time to execute the sql is very fast (16ms) but the time to commit the data is very very slow (2293 ms, even some time more than 10 secondes !)
Time to execute the sql: 16 ms
Indexed Read: 117
Non Indexed Read: 0
Inserts: 30
Updates: 0
Deletes: 30
Time to commit the data: 2293
the tables where the record was inserted/deleted have lot of indexes (around 30 index by table, and around 10 columns by table)
thanks by advance for your help
stephane