Re: [sqlite] Sqlite reading all column data on selects.

In the relational model, the unit of access is a tuple so you would expect a DBMS to process all columns. Typically they also access in units of a page (although a tuple of course might extend across more than one page) The discussion seems to have moved onto selecting pages. Surely if you need t

Re: [sqlite] Sqlite reading all column data on selects.

Am Thu, 24 Sep 2009 14:18:33 -0400 schrieb D. Richard Hipp: > When autovacuum=FULL or autovacuum=INCREMENTAL and SQLite needs to > seek to the end of a long chain of overflow pages, it attempts to use > the "pointer map pages" that are available in these modes to locate > the pages without a

Re: [sqlite] Sqlite reading all column data on selects.

On Sep 24, 2009, at 2:09 PM, Martin Pfeifle wrote: > Hi Richard, > > assume I have a table mytable (id, blob1,blob2,blob3,blob4) > where each blob extends over several pages. > > Then I do the following SQL command: > select blob4 from mytable where id = 4711 > > Do I understand you correctly tha

Re: [sqlite] Sqlite reading all column data on selects.

: [sqlite] Sqlite reading all column data on selects. On Sep 24, 2009, at 8:42 AM, Adam Panayis wrote: > Hi, are there plans to stop sqlite3 from reading in all column data on > specific select queries? i.e I would like sqlite to ONLY read column > data for columns which are specified in t

Re: [sqlite] Sqlite reading all column data on selects.

On Sep 24, 2009, at 8:42 AM, Adam Panayis wrote: > Hi, are there plans to stop sqlite3 from reading in all column data on > specific select queries? i.e I would like sqlite to ONLY read column > data for columns which are specified in the select and where clauses. Short answer: Already does tha

Re: [sqlite] Sqlite reading all column data on selects.

Adam Panayis wrote: > Hi, are there plans to stop sqlite3 from reading in all column data on > specific select queries? i.e I would like sqlite to ONLY read column > data for columns which are specified in the select and where clauses. What do you mean by "reading in" here? I'm not sure I understa

Re: [sqlite] Sqlite reading all column data on selects.

Hello, Adam, Regarding: "... are there plans to stop sqlite3 from reading in all column data on specific select queries? i.e I would like sqlite to ONLY read column data for columns which are specified in the select and where clauses." I'm no sqlite expert, and moreover I'm not sure I understand

[sqlite] Sqlite reading all column data on selects.

Hi, are there plans to stop sqlite3 from reading in all column data on specific select queries? i.e I would like sqlite to ONLY read column data for columns which are specified in the select and where clauses. Thanks. Adam. ___ sqlite-users mailing li