Re: [sqlite] B-Tree usage

Thank you. That clear things up. On Fri, May 10, 2013 at 11:28 PM, Nico Williams wrote: > On Sat, May 11, 2013 at 1:12 AM, Igor Korot wrote: > > On Fri, May 10, 2013 at 11:07 PM, Nico Williams >wrote: > >> It'd help if you posted a simplified schema and statements that are > >> not planned corr

Re: [sqlite] B-Tree usage

On Sat, May 11, 2013 at 1:12 AM, Igor Korot wrote: > On Fri, May 10, 2013 at 11:07 PM, Nico Williams wrote: >> It'd help if you posted a simplified schema and statements that are >> not planned correctly by SQLite3. > > I'm not saying that my statements are not planned correctly. > What I'm saying

Re: [sqlite] B-Tree usage

Hi, Nico, On Fri, May 10, 2013 at 11:07 PM, Nico Williams wrote: > It'd help if you posted a simplified schema and statements that are > not planned correctly by SQLite3. > I'm not saying that my statements are not planned correctly. What I'm saying is that by reading the link above _I_ gather:

Re: [sqlite] B-Tree usage

It'd help if you posted a simplified schema and statements that are not planned correctly by SQLite3. Nico -- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] B-Tree usage

SQLite3 only uses B-trees, for tables and indexes. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] B-Tree usage

Hi, ALL, Looking at http://www.sqlite.org/eqp.html#section_1_2 it would be nice to mention in which case B-Tree is unavoidable. Only one use case with B-Tree vs indexing is used but from reading first paragraph it looks like indexing is B-Tree replacement everywhere. I have a query with ORDER BY

Re: [sqlite] SQLite B-tree API

On Tue, Sep 28, 2010 at 2:01 AM, wrote: > Hi, > Has anyone tried (successfully or unsuccessfully) anything along the line > of using just the B-tree APIs of sqlite as disk-based b+ tree library ? > Looking at the source code it looks like B-tree APIs are not really > exported > but could be, wit

[sqlite] SQLite B-tree API

Hi, Has anyone tried (successfully or unsuccessfully) anything along the line of using just the B-tree APIs of sqlite as disk-based b+ tree library ? Looking at the source code it looks like B-tree APIs are not really exported but could be, with little bit of a hacking. Please share your experien

[sqlite] B#

This is an interesting development for embedded system developers who use Sqlite. http://www.embedded.com/showArticle.jhtml?articleID=183700818 http://www.embedded.com/showArticle.jhtml?articleID=185302940 Quote - The week before ESC Silicon Valley, the number of you who clicked on Part 1 in "