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
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
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
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ʎ ɟı
4 matches
Mail list logo