Re: [sqlite] Inserting/removing large number of rows with index

On Fri, Jan 16, 2015 at 3:47 AM, Hick Gunter wrote: > It depends in how you define "update the index". > > If you mean "write to disk" then this happens "once, at the end of the > transaction" (the exact process differs depending on the journal mode). > > If you mean "change

Re: [sqlite] Inserting/removing large number of rows with index

Jänner 2015 22:19 An: General Discussion of SQLite Database Betreff: [sqlite] Inserting/removing large number of rows with index Hi, If I have a table with an index, and INSERT or DELETE a large number of rows in one statement, does sqlite stop to update the index for each record, or is it smart enou

Re: [sqlite] Inserting/removing large number of rows with index

On 2015/01/15 23:18, Baruch Burstein wrote: Hi, If I have a table with an index, and INSERT or DELETE a large number of rows in one statement, does sqlite stop to update the index for each record, or is it smart enough to update the index just once for all the changed records? In a B-Tree

[sqlite] Inserting/removing large number of rows with index

Hi, If I have a table with an index, and INSERT or DELETE a large number of rows in one statement, does sqlite stop to update the index for each record, or is it smart enough to update the index just once for all the changed records? -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı