Re: [sqlite] Anomalously slow performance on updates to earlyentries in a DB

g Unit > Northrop Grumman Information Systems > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] > on behalf of O'Toole, Eamonn [eamonn.oto...@hp.com] > Sent: Friday, November 09, 2012 8:53 A

Re: [sqlite] Anomalously slow performance on updates to earlyentries in a DB

Thanks again Clemens. > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Clemens Ladisch > Sent: 09 November 2012 15:08 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Anomalously slow perform

Re: [sqlite] Anomalously slow performance on updates to earlyentries in a DB

O'Toole, Eamonn wrote: > DELETE FROM object > WHERE name = ? AND (created_at < ?) This needs an index with "name" as the *first* column. > query += ' AND deleted IN (0, 1)' If the name column is (nearly) unique, putting indexes on the c

Re: [sqlite] Anomalously slow performance on updates to earlyentries in a DB

on behalf of O'Toole, Eamonn [eamonn.oto...@hp.com] Sent: Friday, November 09, 2012 8:53 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Anomalously slow performance on updates to earlyentries in a DB > -Original Message- > From: sqlite-users-boun..

Re: [sqlite] Anomalously slow performance on updates to earlyentries in a DB

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Black, Michael (IS) > Sent: 09 November 2012 14:26 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Anomalously slow perform

Re: [sqlite] Anomalously slow performance on updates to earlyentries in a DB

>[O'Toole, Eamonn] This definitely sounds like it could be an issue. There is >just one container_stat entry >confirmed by sqlite3_analyzer output which I'll >post later). So you're saying that the single container_stat table :entry is >potentially being relocated very frequently the closer th