[sqlite] how sqlite works?

2006-09-15 Thread Cesar David Rodas Maldonado
If there a document of how SQLite Virtual Machine Works ( papers )? I would like do something similar with B-Tree, B+ Tree but i dont know how to merge a select with tow Index? Understand my question?? Please answer me

Re: [sqlite] how sqlite works?

2006-09-15 Thread Dennis Cote
Cesar David Rodas Maldonado wrote: If there a document of how SQLite Virtual Machine Works ( papers )? I would like do something similar with B-Tree, B+ Tree but i dont know how to merge a select with tow Index? Understand my question?? Please answer me see the links VDBE Tutorial and VDBE Op

Re: [sqlite] how sqlite works?

2006-09-15 Thread Cesar David Rodas Maldonado
I meen, If SQLite has two index and very large Index (about 10.000.000 each one) how do i merge it, I mean (index1 = index2 for every one and limit it in thousand). Understand? On 9/15/06, Dennis Cote <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado wrote: > If there a document of how S

Re: [sqlite] how sqlite works?

2006-09-19 Thread Christian Smith
Cesar David Rodas Maldonado uttered: I meen, If SQLite has two index and very large Index (about 10.000.000 each one) how do i merge it, I mean (index1 = index2 for every one and limit it in thousand). Understand? I guess not. Are you trying to do an INNER JOIN merger on the two indexes? SQ

Re: [sqlite] how sqlite works?

2006-09-19 Thread Cesar David Rodas Maldonado
Thanks for your answer Ms. Smith! On 9/19/06, Christian Smith <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado uttered: > I meen, If SQLite has two index and very large Index (about 10.000.000each > one) how do i merge it, I mean (index1 = index2 for every one and limit it > in thousand)

Re: [sqlite] how sqlite works?

2006-09-20 Thread John Stanton
I suggest that you get Donald Knuth's books (Fundamental Algorithms, Sorting and Seaching and Semi-Numerical Algorithms). They have everything you need to know, and plenty more. Knuth explains various type of B-Tree and plenty of merging algorithms. Cesar David Rodas Maldonado wrote: I meen

Re: [sqlite] how sqlite works?

2006-09-21 Thread Cesar David Rodas Maldonado
Ok Thanks John I will try to buy! Thanks everybody for your help! On 9/21/06, John Stanton <[EMAIL PROTECTED]> wrote: I suggest that you get Donald Knuth's books (Fundamental Algorithms, Sorting and Seaching and Semi-Numerical Algorithms). They have everything you need to know, and plenty mor

[sqlite] How sqlite works? Parsing SQL ect

2006-11-07 Thread Peter Michaux
Hi, I would like to build a very light SQL database in javascript. I would like to learn how sqlite parses an SQL statement and then acts on this parsed information. Does anyone have a pointer to a link or book that explains the process at a higher level then source code? Thank you, Peter -

Re: [sqlite] How sqlite works? Parsing SQL ect

2006-11-07 Thread Roger Binns
Peter Michaux wrote: Does anyone have a pointer to a link or book that explains the process at a higher level then source code? http://sqlite.org/arch.html Roger - To unsubscribe, send email to [EMAIL PROTECTED]